Love the way how you hacked green vs red when there's no FX button. I did the same for a YOY change bar chart combined with Calculation groups - one group only calculated the negative values and the other calculated the positive ones. So 2 item used in the bar chart visual and now I could set CG1 to red and CG2 to green.
The Power BI design master. No idea how you figure these things out but exceptional as always. Everything worked perfectly except the negative data label on the constant line. Mine returns to the positive side. I'll keep playing with it to figure out where I failed. As always, thanks so much, Bas.
Hi Bas, thanks for this awesome vid. I have a problem aligning the negative label to the left just like yours. It goes to the right along with the positive label.
That's amazing. I have a question. if instead of Product I have Slice by 3 differents like Products, brand and category and I want the line be relative as well when we choose from Slice by how we would change the formula on Variance instead of Product column?
Thanks for this great idea - I can't figure out how to get the error bars working from the constant centre line, or any constant line for that matter. Any thoughts on why that might not be working for me?
That was a brilliant solution, I'm in the process of incorporating it into my reports. A question, do you have an idea how to change the deviation in chart 1 to relative?
Excellent contribution and thanks for the resource. I was reviewing the file and when I select the year 2020 and a category the following happens 1) when I select a year and a category, one or more negative lines overlap the bars of the current value and I don't know how to prevent them from overlapping 2) Is there any way to dynamically adjust and overlap neither the lines nor their labels on the bars of the current value? I would greatly appreciate your contribution
I love that you demonstrated this new feature as I didnt know about the error bars. That said, I dont know if this is so practical in a business setting where charts tend to be more dynamic. Seems to be way too much input just for one chart and possibly a hassle to troubleshoot if one of the measures buried in the error bars is faulty. But I'll explore it. Thank you.
Awesome Bas, as always! I'm wondering if it's possible to include outliers in the box plot chart maybe as dots instead of using the max/min as 0.95/0.05 percentile! Do you think could be useful or not for the box plot chart?
Très instructif, Par ailleurs, je sais pas comment vous avez reussi a afficher l'étiquettes de label positive left tout a fait a droite. Je selectionne bord extérieur mais ça le positionne sur la ligne, et si je sélectionne bord intérieur, ça s'affiche pas
Got my chart in! Looks TOP NOTCH! I can control the hover over effect by turning off the tool tips or adding a tooltip page, but , Any suggestions on how to handle all the Placeholder data when you right click "Show as Table"
that's awesome 🎉🎉 I don't think there is a good solution for that just yet. You could hide it, but I guess you still want it but just without the dummies
Hello, I have a problem with the values, due to the great difference in the variation, they overlap the bars. However, try changing the number that is multiplied by 1.75 to 3.25 and so on, they continue to overlap, any ideas? greetings
Can we do this for current vs Previous, I am trying the same but I am only getting previous month info only example Feb data only not the difference between Jan and Feb
In a slicer visual we search for a keyword in the result we get 10 or 20 , results how can we select all the results in a single click. Is there any possibility to do that??
I am using the most current version (Version: 2.136.1202.0 64-bit (September 2024)) but missing some of the features - like reference line or error bars How comes that? Do i need to activate those features manually?
What a fantastic chart Bas - now my most favourite chart of all. I'm looking to replace so many column and bars with this. If anyone is interested, I have replaced the circle icons with ▼ for neg and▲ for pos. Whilst there is only actually one triangle ▲ icon available, place the the neg measure into the lower bound (see video point 7:30). Now the chart will compensate either for rows or for columns. Thank you so much for this Bas
Please please help. Power Query. Somewhere I saw you can get a result in a step, then export that result to another query, come back to this query and ref the step before "exporting" and carry on with the current query.
Hey there, I think I've done this before. The trick was instead of the query being a query end product, you convert it to a list. Removing the starter stuff like Let... and the In stuff at the bottom I think will achieve this. You then have a list that allows you to reference any of the steps in another query.
Just different layout for the formatting options. I have under preview ob object formatting on. In your layout it is on de analytics tab right next to formatting
Great job! I'm always amazed by your creativity! I'm not sure how did you managed to set the left label (for the first chart) in place. If anyone has the same problem, I subtracted a small amount from the formula for the left label (such as 5% of the "Revenue Variance Center")
I had that same problem! Selecting Outside End placed the label on top of the bar. So frustrating. I can't say exactly how I resolved it, as there was a lot of try this, that, and the other...But the end solution uses Inside End as the position. I feel like doing just that didn't do the trick. I toggled the transparency of that bar from 100% to
There's no doubt these look great, but for a large enterprise with a thin report setup it's totally impractical to have this many measures required for one visual. In my case I have a model that serves 120 reports, this model naturally already has 1000's of measures. Do you have any visual best practice guides which account for these instances?
Looks cool but the rendering the visual took really long for me. It's not the case when I use the same measures without the lollipops. Also creating the visual took some time, I wish powerbi just add these options efficiently and easily as core visuals.
Wow the click tax is insane - and he got every single one correct. The average user is clicking on every second sub menu trying to find the right place to make a formatting change.
same technique .. if you want to have different colors you could still add another dummy that conditionally shows for a certain category in a different color
This youtube channel does not talk about power bi, it's all about magic
Awesome Bas! Nice method of setting the bar chart 🔥
😎👊
New hands on Power BI, Your Tips have actually being a great inspiration. You do pure Magic there.
😎👊
Love the way how you hacked green vs red when there's no FX button. I did the same for a YOY change bar chart combined with Calculation groups - one group only calculated the negative values and the other calculated the positive ones. So 2 item used in the bar chart visual and now I could set CG1 to red and CG2 to green.
thank you! a fx button would have been nice though 😅😁
This is so insane! Your video tips help me a lot. Many thanks Bas!
Happy to help! 😊thanks for watching them
Thanks!
Wow! Thanks for supporting the channel ✌️🔥
Amazing! excellent way to show the variances without showing them in a typical table... I am going to apply them shortly. Thanks for all you share!
The Power BI design master. No idea how you figure these things out but exceptional as always. Everything worked perfectly except the negative data label on the constant line. Mine returns to the positive side. I'll keep playing with it to figure out where I failed.
As always, thanks so much, Bas.
Hey Bas, thanks alot for this amazing tutorial, I was wondering if there a way to add a variance % on the reference line?
Which visualisation u r using , in my Power bi Pro i am not able to see reference line option and many others also ? Please advice
how ever, great video y content , just a question, it can do it , adding the var % , another vertical line side by side?
Hi Bas, thanks for this awesome vid. I have a problem aligning the negative label to the left just like yours. It goes to the right along with the positive label.
That's amazing. I have a question. if instead of Product I have Slice by 3 differents like Products, brand and category and I want the line be relative as well when we choose from Slice by how we would change the formula on Variance instead of Product column?
Thanks for this great idea - I can't figure out how to get the error bars working from the constant centre line, or any constant line for that matter. Any thoughts on why that might not be working for me?
awesome! thanks for great content . one question: how do show outliers with this trick of yours
That was a brilliant solution, I'm in the process of incorporating it into my reports. A question, do you have an idea how to change the deviation in chart 1 to relative?
Excellent contribution and thanks for the resource. I was reviewing the file and when I select the year 2020 and a category the following happens
1) when I select a year and a category, one or more negative lines overlap the bars of the current value and I don't know how to prevent them from overlapping
2) Is there any way to dynamically adjust and overlap neither the lines nor their labels on the bars of the current value?
I would greatly appreciate your contribution
Awesome Bas ! By setting up a new chart using error bars, I am becoming a big fan. You have created a very nice visualization
i'm using PowerBI Version: 2.128.1380.0 64-bit (April 2024). There is NO SUCH OPTIONS as REFERENCE LINE underneath Plot Area Background.
Superb work!!! This will be used on next assignment, much appreciated!!
Awesome Bas, I have been waiting for these from ages.
I love that you demonstrated this new feature as I didnt know about the error bars. That said, I dont know if this is so practical in a business setting where charts tend to be more dynamic. Seems to be way too much input just for one chart and possibly a hassle to troubleshoot if one of the measures buried in the error bars is faulty. But I'll explore it. Thank you.
Useful on projects im working, bet for most others here too
Awesome ! I will be use this in my reports , but how I can arrange and organize my measures in a folders and sub folders like you ?
here you go ruclips.net/video/cGnWPua-cmo/видео.html
Awesome Bas, as always! I'm wondering if it's possible to include outliers in the box plot chart maybe as dots instead of using the max/min as 0.95/0.05 percentile! Do you think could be useful or not for the box plot chart?
Amazing, such a creative approach to take advantage of every new features release
Do you have similar content also for Tableau?
Très instructif,
Par ailleurs, je sais pas comment vous avez reussi a afficher l'étiquettes de label positive left tout a fait a droite. Je selectionne bord extérieur mais ça le positionne sur la ligne, et si je sélectionne bord intérieur, ça s'affiche pas
what if the variance (Revenue Actuals CY vs PY ) has negative value? how will the error bars be shown or be adjusted/modified to show correctly?
What screen recorder software did you use for your video?
Wow, nice timing, I am literally just now trying to add a dumbell chart. This new functionality is awesome, thanks for the very useful vid
ah perfect, especially for you a timed it like this 😋😉
Hey Bas, how did you create the Metrics folder on its own? - 1:43
Clean up your DAX measures with MEASURE TABLES and FOLDERS in Power BI
ruclips.net/video/cGnWPua-cmo/видео.html
Got my chart in! Looks TOP NOTCH! I can control the hover over effect by turning off the tool tips or adding a tooltip page, but , Any suggestions on how to handle all the Placeholder data when you right click "Show as Table"
that's awesome 🎉🎉 I don't think there is a good solution for that just yet. You could hide it, but I guess you still want it but just without the dummies
OK, " Stayed Tuned" is fair! Thanks for the quick response! @@HowtoPowerBI
Wonderfully incredible. I wonder how many hours you spend figuring out these tricks. Congratulations on the work!!!
thank you! this was actually a quick one, cause I was waiting for it to be there one day lol ( some others take me a looooot of time )
@@HowtoPowerBI Wow 🤯
Bas your creativity is insane! Thanks for sharing.
All those dummy measures could be declared with the new feature in the visual or there are some limitations?
the visual calculations? yes, that would work!
Thanks, Bas! Had NO idea that Feb 2024 update snuck it in there. 😀 Miguel has been keeping himself busy, I see! 😉
visual calculations were getting the spot light this month lol ;)
How did you get that pop up dialog box that shows the emojis? The one you used to create the delta triangle? Is that a native keyboard shortcut?
Windows key + . (Period)
can this work in "line and clustered column chart"?
Hello, I have a problem with the values, due to the great difference in the variation, they overlap the bars. However, try changing the number that is multiplied by 1.75 to 3.25 and so on, they continue to overlap, any ideas? greetings
Can we do this for current vs Previous, I am trying the same but I am only getting previous month info only example Feb data only not the difference between Jan and Feb
Month vs month would also work, all the same logic as in video
Bas, you are the best and I mean it, thanks man.
Amazing work Bas!! Love your workarounds and little "hacks" for PBI 😊
Thanks! 😀
Brilliant :) Power BI's Viz options are catching up to Tableau's beautiful Viz designs
slowly getting there 😀
In a slicer visual we search for a keyword in the result we get 10 or 20 , results how can we select all the results in a single click.
Is there any possibility to do that??
This was super helpful, thank you!
I am using the most current version (Version: 2.136.1202.0 64-bit (September 2024)) but missing some of the features - like reference line or error bars
How comes that? Do i need to activate those features manually?
That was a really cool demo. Thanks for sharing!
🚀thx!!
another incredible one from the Guru
😊😊😊 thank you
Amazing! Really appreciate your pursue to perfection 🌟
Thank you for all the great tips and also thank you for wearing that shirt! 😍
Anyone figure out how to make the colors dynamic for the error bar circles in the second example?
What a fantastic chart Bas - now my most favourite chart of all. I'm looking to replace so many column and bars with this.
If anyone is interested, I have replaced the circle icons with ▼ for neg and▲ for pos. Whilst there is only actually one triangle ▲ icon available, place the the neg measure into the lower bound (see video point 7:30). Now the chart will compensate either for rows or for columns.
Thank you so much for this Bas
awesome, thx for watching Paul
I have updated to current version still for me reference line option is not showing
it s on the analytics tab for you (right next to formatting) .. or you turn on on object under preview options and it looks the same as mine
how should the data be structured for this
Please please help. Power Query. Somewhere I saw you can get a result in a step, then export that result to another query, come back to this query and ref the step before "exporting" and carry on with the current query.
Hey there, I think I've done this before. The trick was instead of the query being a query end product, you convert it to a list. Removing the starter stuff like Let... and the In stuff at the bottom I think will achieve this. You then have a list that allows you to reference any of the steps in another query.
why i cant find the reference line bottom
hat off = amazing Bas!
Awesome. I’m slowly learning with your contents as beginner.
why not fast 😋 .. awesome, happy to be part of your learning journey
Brother, I love you videos🥰
this video is very perfect！！！ thank you
as always very helpful videos , really liked it 👍
p.s. when you first said ERROR BARS, I was like what is ARAB BARS ? 😅
Yea i m trying to promote my new product arab bars ;)
Why is the reference line tab not available in my chart?
Just different layout for the formatting options. I have under preview ob object formatting on. In your layout it is on de analytics tab right next to formatting
Where is the overlap now? Can't see it anymore in bars layout
Awesome! Other than Power bi, I want to learn "Editing" from YOU!!!
🙏 thanks , maybe for a different channel lol
How to enable overlap options in power Bi Desktop 12:44
The reference line option is not seen in my power bi
Go to the analytics tab or turn onobject formatting on to have the same menu latout
@@HowtoPowerBI got it .thnks
excellent content man! as always
Appreciate it!
Amazing lesson. Thanks heap.
Glad you liked it!
I love your chart 2, bravo 🎉
thanks!! 😁
nice trick. bravo. thank you for sharing
😊 thx
It's a shame that "Reference Line" selection yet to be added to Power bi in Australia! :(
Great job! I'm always amazed by your creativity! I'm not sure how did you managed to set the left label (for the first chart) in place. If anyone has the same problem, I subtracted a small amount from the formula for the left label (such as 5% of the "Revenue Variance Center")
I had that same problem! Selecting Outside End placed the label on top of the bar. So frustrating. I can't say exactly how I resolved it, as there was a lot of try this, that, and the other...But the end solution uses Inside End as the position. I feel like doing just that didn't do the trick. I toggled the transparency of that bar from 100% to
a greate vedio Could you share file as pbix plz
See download link in description
Best video seen today
hope it wasn't the first one then :p .. thank you!
hello! New to power bi and I wanted to say even though I have the new update I can't find the Reference line
I have the Feb 2024 version
turn on object on under preview options .. or go to the analytics tab to add a constant line
@@HowtoPowerBI Thank you so much
Excellent 🎉thanks for sharing 👍
Thank you! Cheers! 😊
Brilliant ❤
wow, it's incredible!
thanks!!!
Hey Bas, Are you author of any design book? If not already then you should write one on Power BI Designs.
No, got 30hours + video training on it though
@HowtoPowerBI Can you share the link with me pls 😊
datatraining.io/powerbidesigntransformation
Awesome Bas!
thank you!
I have Feb 2024 version but can't see Reference Line option
Is it clusteeed bar chart
Yes
There's no doubt these look great, but for a large enterprise with a thin report setup it's totally impractical to have this many measures required for one visual. In my case I have a model that serves 120 reports, this model naturally already has 1000's of measures. Do you have any visual best practice guides which account for these instances?
Awesome 👌
🙌
BRUHHHH SO COOL!
😎👊
Amazing
Looks cool but the rendering the visual took really long for me. It's not the case when I use the same measures without the lollipops. Also creating the visual took some time, I wish powerbi just add these options efficiently and easily as core visuals.
maybe try zebra bi cstom visual , easier to create a chart like this one .. not a native visual though
Nice!!
thanks! 😊
awesome!
😎👊
The trick enhancess the visual appeal of Power BIdashboardsh creativity! Thanks
So smart. Nifty
thanks!!
Now I am going to change few graphs of my customers and my boss would be wow 😂😂
:p and was the reaction as you hoped for lol 😁😊
Wow the click tax is insane - and he got every single one correct. The average user is clicking on every second sub menu trying to find the right place to make a formatting change.
😉it's edited , also I click on the wrong stuff sometimes
When you go with first chart the amount of workarounds applied gave me headache :D
Lol 😂. Its the same trick though, applied 10x
Please make a clustered box plot with this new feature
same technique .. if you want to have different colors you could still add another dummy that conditionally shows for a certain category in a different color
power BI pro max
Tableau in trouble 😂😂😂
❤
☺️
Bas tu devrais te faire embaucher par Microsoft Design !
merci! Je ne sais pas cependant si c'est quelque chose auquel j'aspire ;)
Perfect,
Thank you!!!!😊
i love you