This is exactly the solution I was searching for. Thank you!
@BenHoward_PowerBI
Жыл бұрын
Fantastic!!
@flexyourdata
4 ай бұрын
Thanks. Great video. It's wild to me that we have to use error bars to achieve this effect.
@BenHoward_PowerBI
3 ай бұрын
Glad it was helpful!
@fungi2732
Жыл бұрын
i found lipstick chart to be perfect to show planned vs actual figures. However a chart i found appeared to be a paid version, but who wants to pay money these days lol i am very happy that I found you video, I could fully replicate the paid lipstick version with your example so thanks very much! very useful
@BenHoward_PowerBI
Жыл бұрын
You are very welcome! - thanks for the feedback and please subscribe to the channel.
@TarekElduzdar
Жыл бұрын
Brilliant! Thank you!
@BenHoward_PowerBI
Жыл бұрын
You're very welcome! Please subscribe to the channel, it helps me out!
@imainek.6244
2 жыл бұрын
Thank you very much your video was quite helpful :) !
@NM-hs8yw
Жыл бұрын
Thanks for the video! Is there a way to make conditional formatting for the color of error bar? Green if error bar is higher and red if lower than the 1st value?
@BenHoward_PowerBI
Жыл бұрын
Hi, that would be a great addition, but alas there is no conditional formatting available for the error bar.
@MuhammadRizwan-tc3zp
Жыл бұрын
Thanks for the trick and you nicely hide the Lower Bound zero by keeping the color of the error bar and label of same color .... but tell me how to actually remove the 0 Lower Bound!! kindly respond and help.
@noamfauvel3457
Жыл бұрын
Hi, did you find a solution?
@MuhammadRizwan-tc3zp
Жыл бұрын
@@noamfauvel3457 yes somehow. I used DENEB 3rd party tool in power bi and made my custom lipstick charts.
@leslieware9960
Жыл бұрын
This is awesome! I followed along and noticed that when I turn my error labels on, it shows the lower bound of 0 in addition to the upper bound. Is there something I did wrong?
@BenHoward_PowerBI
Жыл бұрын
I'm not sure why that would be, happy to have a look at the file if you want to email it over to me.
@ethanmacraecomposer
Жыл бұрын
@@BenHoward_PowerBI Great video! Please let me know if you manage to figure this out. I'm also seeing the lower bound.
@BenHoward_PowerBI
Жыл бұрын
@@ethanmacraecomposer - I have found the issue (Microsoft have updated the chart visual to display the lowerbound number). To fix this you can do the following. 1. Select the chart, and then the Analytics icon -> Error Bars -> Error Labels 2. Switch the "Match Series Color" slider to off. 3. Select the color which matches the bar (in my case black). This prints the lowerbound number onto of the black bar, so in my case, black on black - this means you cannot read the lowerbound number.
@BenHoward_PowerBI
Жыл бұрын
- I have found the issue (Microsoft have updated the chart visual to display the lowerbound number). To fix this you can do the following. 1. Select the chart, and then the Analytics icon -> Error Bars -> Error Labels 2. Switch the "Match Series Color" slider to off. 3. Select the color which matches the bar (in my case black). This prints the lowerbound number onto of the black bar, so in my case, black on black - this means you cannot read the lowerbound number. I have updated my github file to reflext this.
@user-qt9cz2kp6w
10 ай бұрын
Amazing tutorial!!! Just one doubt, hope you can help me: Is there a way to change the "Label Name" showed when you move the cursor over the graph??, I mean, it tells you the "Lower Limit" as "Lowercase" and the comparasion measure as "Uppercase"; can we change those labels for ones more descriptive??
@BenHoward_PowerBI
9 ай бұрын
Yes you can - you can choose what is displayed by using a different tooltip, you can even set up your own tooltips.
Пікірлер: 21