Our 'Out of the Box Thinker' has returned with even more remarkable insights. Bas, you, Sir, continue to be an exceptional mentor in the realm of Power BI learning. Gratitude as always 🙏
Simply, perfect. You can put together great ideas, really functional and native tricks. Plus a great way to explain. A special highlight to the editing of the video, sensational. Thanks dude.
This was absolutely MIND BLOWING! We have a debate in my company about Power BI vs Tableau. People say Power BI is better for modeling, but Tableau is better for customizing visualizations. You, sir, are proving them wrong. I cannot wait to try this out.
If the "label" bars are a static number, you may have inconsistent label bar sizes when the main bar value changes drastically. Use a custom x-axis range maximum and a dynamic "Dummy" measure to fix this, like for example: Dummy = VAR _dynamicwidth = CALCULATE( MAXX( SUMMARIZE( YourTable, YourTable[Category], "totals", Max/Sum/distinctcount(YourTable[metric]) ), [totals] ), ALL('Category)) RETURN _dynamicwidth * 0.5
Bas, you are very creative indeed. At the same time, I can’t get why not use for the same purpose a Matrix/Table visual instead of a Bar chart. Using a matrix allows to display a bar indicator either by conditional formatting or by svg code. Moreover, the dummy measure (2000000) will not look nice always. If there were other filters applied, then Total Sales might be reduced, for example, 100000 times. That fact would distort the chart as the Dummy measure would take a huge amount of space. I understand that Dummy measure logic could be built up to handle that case, but as I already said why not just use Matrix instead.
indeed the dummy measure I adjusted (at the end of the vid). matrix could also get you close i guess, will give it a try to see how the end visuals would compare.
Thank you, your videos helps in making creative Dashboards and i love to watch them. Can you please DAX formula for ItemRank Last Year and Current Year please.
Looks great. But what if the bar chart is linked to a slicer. the dummy measure (number value) needs to be also dynamic. Its value needs to be a function of the bar size.
Thank you for another great video :) I know it will probably be difficult for you to answer, but sometimes it happens to me that I don't have the right sequence of ranking numbers. For instance: #1,#2,#4,#3
You read my thoughts! 😂 I'm only starting to work on the project where I'll need this kind of visual and was only starting to think over how to realise this when you just made it ready to use)
Awesome video! The only thing I couldn't get to work in my application was the coloring of the rank. It wouldn't allow me to put the measure (Ranking Development Color) in the conditional formatting dropdown. I'm on the Feb2024 version of Power BI. I used the exact same format of the measures that you did. Any suggestions?
Bas, your last 3 videos are so awesome, tnaks for share your knowledge with all of us. Do you think it's possible include images in the same parte where you put the rank and variation information?
great video, may i know how you create the Rank for current and last year measure? and can i change it according how i analyze it (for example to month or year or quarter)?
Wow this is amazing! How do you did you get this ideas? Did you have special business problem to solve, did you see something similar being done, or is was it just a moment of inspiration? I will defo use this for ranking trend data. Thanks fot sharing.
Hi Bas, I've followed your steps exactly (as far as I can tell), and at the step around the 6 min. mark where you move the Dummy value to the top of the X Axis, when I do that step it changes the ranking order. Now it orders them alphabetically by the Legend name (Alabama, Canada, etc.). It maintains the rank # correctly, but I still want it to sort by Rank from highest to lowest. Any ideas why this might be happening?
Bas, one quick suggestion, when you use a keyboard shortcut (different than Ctrl+C Ctrl+V) you could put in a small text in the screen that clarifies it for the people. I would have missed the Ctrl+Shift+L here if i hadn't gone back thanks!
Bas, I can see that you are using the new contextual menus for the formatting of te visuals, truth be told, did not find them quite useful when they were launhced so I just deactivated them. Have you found any real benefit from using those in your experience or you just did the opposite of me (went on and never look back) ? cheers man!
I'm switching back at forth (some trainings I do on older versions). The new layout is a lot of clicking. But I guess its not gonna go away so think it is better to get used to it. guess it will also still improve ovr time
I am not able to create the dummy table i keep getting "The expression specified in the query is not a valid table expression." notification every time i try to create a dummy. Can someone help me with this!
Thanks again for the great video! One question, how would you fix the Tooltip? If you hover on the part of the bar chart where it shows the ranking, it'll show a dummy measure. That doesn't look to good, do you have a way to fix that?
If you create a custom tooltip on another report page and turn it on as a tooltip for this visual, it should replace the native/automatic tooltips. you could do something as simple with the measure label and value. and try to format it to look as closely to automatic tooltips as you want (or just be creative and have fun with it and purposely make it different).
Hi Bas, This is great, one question. When I add a Dummy I can no longer have a Legend added. Is there a way to include a dummy spacer and then the actual values but retain the legend. For example I have a bar that represents multiple operating companies, I show the total revenue and have sections within the stack for each Operating company. The bar is related to each country and I want to rank the countries showing the top 10 and then include the rank development. Is that possible?
@@HowtoPowerBI I mean a slicer with just a calendar in descending order with only one select option. The calendar cannot have both from and to date selection option as we get in the slicer using between dates option
It's kind of hilarious but ever single one of your videos is is like ' Look at this new power BI feature. Let's hack it!' Why do Microsoft impliment features that are so close, but miss the beat? Having to do hacky shit to make a half decent dashboard shouldn't be the norm. Excellent video as always
Hi Bas, a small request..... Can you please make a video on map visuals in power bi with data lable. As Power bi default visual is not allowong me to put data lable over each states. Thanks
Always amazed at your content and it helps a ton as I am very early on in my PBI journey. Thanks for sharing your knowledge with us. One question about something I noticed here - multiple items in the final dummy label areas showed their previous rank as “1” and I’m assuming they were in the teens between 10-19 (or 100’s) but the label was just a little too small to show the whole number. What’s the best way to correct this, make the dummy measure 3 million so it takes up more space on the stacked bar or would we also need to do something with the label itself? Thank again!
yea got a few, you could use field parameters -> ruclips.net/video/-nqEv2YXLsU/видео.htmlsi=brtQTLgelELNfrIk automatic period selection -> ruclips.net/video/KReYWx5NXYg/видео.htmlsi=LN5bLADqW0S4EmtL .. bookmarks -> ruclips.net/video/cYwioeHu_OU/видео.htmlsi=EM8m-Lm0-egeZRfJ
Hi Bass. Please help me. Icons are not displayed on my chart. Only if in table visualization or September 2023 pbi version. I tried to simply insert an icon with a unicode number without a DAX, but it only prints the unicode number and does not display the icon. Our enterprise version is from May 2023. Could this be causing the problem or could it be a setup issue? Thanks for your help.
Hi Bas, great works. What are the measures you used for "Item rank CY and Item Rank PY. I used this Item Rank LM (last month)= CALCULATE( [Item Rank], DATEADD( 'Date'[Date], -1, MONTH ) ) This month : Item Rank TM = CALCULATE( [Item Rank], Tablename, ALLSELECTED('Date'[Date])) But return #1 for all left hand side rank of my dimension. Thanks
Learn everything I know about designing Power BI reports datatraining.io/powerbidesigntransformation
Hi Bas, can u tell me please in what currency the price of the program is?
@@juanignacioXI it is in euros
Our 'Out of the Box Thinker' has returned with even more remarkable insights. Bas, you, Sir, continue to be an exceptional mentor in the realm of Power BI learning.
Gratitude as always 🙏
that's really nice to hear 😊 happy you get some value out of the vids
Simply, perfect. You can put together great ideas, really functional and native tricks. Plus a great way to explain. A special highlight to the editing of the video, sensational. Thanks dude.
This was absolutely MIND BLOWING!
We have a debate in my company about Power BI vs Tableau. People say Power BI is better for modeling, but Tableau is better for customizing visualizations. You, sir, are proving them wrong. I cannot wait to try this out.
Hey man, you are the reason behind my success. I always look into your videos before starting my work.
that's awesome! happy to hear you are getting some value from my videos 😎👊😊
Incredible work, making visuals more and more end-user friendly with each video.
Glad you like them! 😁😊
If the "label" bars are a static number, you may have inconsistent label bar sizes when the main bar value changes drastically. Use a custom x-axis range maximum and a dynamic "Dummy" measure to fix this, like for example:
Dummy =
VAR _dynamicwidth = CALCULATE(
MAXX(
SUMMARIZE(
YourTable,
YourTable[Category],
"totals", Max/Sum/distinctcount(YourTable[metric])
),
[totals]
), ALL('Category))
RETURN
_dynamicwidth * 0.5
In awe with how you come up with this stuff 💪
Thanks to youtube suggested films panel I found this channel. Your movies show me answers before I ask questions :D Thanks :D
You have amazing power bi content 🔋 keep it up!
Thank you 🙌
Saving this to watch in work tomorrow!
learning and earning at the same time 😁
@@HowtoPowerBI you have no idea how often I watch your videos at work to help me crack stuff
Amazing. Your videos are very very interesting and out of box that conventionally not available on RUclips.
Loving the videos
Bas, you are very creative indeed. At the same time, I can’t get why not use for the same purpose a Matrix/Table visual instead of a Bar chart. Using a matrix allows to display a bar indicator either by conditional formatting or by svg code. Moreover, the dummy measure (2000000) will not look nice always. If there were other filters applied, then Total Sales might be reduced, for example, 100000 times. That fact would distort the chart as the Dummy measure would take a huge amount of space. I understand that Dummy measure logic could be built up to handle that case, but as I already said why not just use Matrix instead.
indeed the dummy measure I adjusted (at the end of the vid). matrix could also get you close i guess, will give it a try to see how the end visuals would compare.
@@HowtoPowerBI Yes, sorry. I missed the part where you adjusted Dummy measure.
Thank you, your videos helps in making creative Dashboards and i love to watch them. Can you please DAX formula for ItemRank Last Year and Current Year please.
+1
Thank you very much for sharing your knowledge with the community
Very impressive, a better alternative to tooltips especially with new PBi users
Beautiful
Thank you 😊
I love how you hack visuals!
can you please explain how you got the "ITEM RANK PY" AND "CY"?
Looks great. But what if the bar chart is linked to a slicer. the dummy measure (number value) needs to be also dynamic. Its value needs to be a function of the bar size.
This is too great. Love it. More videos like these.
Amazing skills! Thank you very much for sharing such great information.
Much appreciated for these design tweaks 🎉🎉
Glad you like them! 😊😎
This is really nice! Most of the time I use a matrix when I want to achieve something like this.
Glad you like it! Yea i guess with a matrix you could get pretty close .. will give it a try to see how the results would compare
Thank you for another great video :) I know it will probably be difficult for you to answer, but sometimes it happens to me that I don't have the right sequence of ranking numbers. For instance: #1,#2,#4,#3
this looks fantastic. thank you for sharing
You are another level mate, thank you!
Bas, you're magic!
good job👌
Another great and useful video, I was just expecting this functionality.
Thanks again, Bas. You are a Master!
Glad you liked it! 😊😁
Amazing, amazing, amazing!
Amazing! Very creative!
Usefully brilliant as usual.
Thanks you for watching! 😊
This is freaking awesome! Thanks a lot!!!
Glad you like it!
simple and amazing!
brilliant, very useful vid, thank you for sharing.
Glad it was helpful! thanks for watching 😊
Another great video! Thank you!
thanks for watching again!! 😊
Awesome Work 👌👌
Great as always, thank you Bas!!
thank you so much Wilco!!!
You read my thoughts! 😂 I'm only starting to work on the project where I'll need this kind of visual and was only starting to think over how to realise this when you just made it ready to use)
project is already half done before you even started 😉😁
Like Vivek Ramaswamy says, if the pack runs in one direction, start running towards the opposite direction
which direction am I running 😁 ?
@@HowtoPowerBI omg 🤣 instead of replying to minority mindset clip, i replied here. Sorry mate😅 love your work
@@lionellawrence5798 lol 😂at least I know now who Vivek Ramaswamy is ;)
Awesome video! The only thing I couldn't get to work in my application was the coloring of the rank. It wouldn't allow me to put the measure (Ranking Development Color) in the conditional formatting dropdown. I'm on the Feb2024 version of Power BI. I used the exact same format of the measures that you did. Any suggestions?
Amazing idea! Thank you, Bas! Wonder if there's an option to turn off the tooltip for dummy part only?
not really, you could simply overlap an invisible shape 😁 maybe not the solution you hoped for but will work
@@HowtoPowerBI Thank you! Yeah, this is not the best solution, but it definitely works!
Please show key to show icon thanks
windows + . (period)
@@HowtoPowerBI thanks u
awesome ! thank you for sharing
Glad you liked it!
Bas, your last 3 videos are so awesome, tnaks for share your knowledge with all of us. Do you think it's possible include images in the same parte where you put the rank and variation information?
Nice one, but I would simply go for table visual and use 4 different columns with last one displayed as bar chart. much simpler setup.
Great suggestion! let me give that also a try and see how the end visuals compare
Awesome!
great video, may i know how you create the Rank for current and last year measure? and can i change it according how i analyze it (for example to month or year or quarter)?
check out the example file for the measure ( download link in the description )
Dope! Thanks master 🙏🎉
😎👊😊
Men u re na artist, so damn cool
Happy 😃 you like it
Wow this is amazing! How do you did you get this ideas? Did you have special business problem to solve, did you see something similar being done, or is was it just a moment of inspiration? I will defo use this for ranking trend data. Thanks fot sharing.
Hi Bas, can we add extra labels to clustered bar/column chart?
Hi, wondering if you have the video explaining how to calculate the rank of the previous month
Thanks Bas
Hi Bas
Amazing video
Hi Bas, I've followed your steps exactly (as far as I can tell), and at the step around the 6 min. mark where you move the Dummy value to the top of the X Axis, when I do that step it changes the ranking order. Now it orders them alphabetically by the Legend name (Alabama, Canada, etc.). It maintains the rank # correctly, but I still want it to sort by Rank from highest to lowest. Any ideas why this might be happening?
this is amazing but it also sounds like something Microsoft can easily add in as a built-in feature. Maybe in due time...
let's hope they do
Love uuu
cool!
i had a conditional formatting on my bars and now i cant use it because i added the dummy measure
Hello Bas, is there any way we can show legend only when a vlaue is selected in slicer
Love it !
yey 🎉
Creativity thinking appreciate🙏
Thanks a lot 😊
Awesome!
Hey! Thank you for this idea. One question about it - my custom labels don't react on cross filtering. Are there any ways to fix this?
Microsoft mentions a new feature in PowerBI with a bullet point in a slide deck. Bas turns it into a world-class how-to video!
Amazing 🎉❤
Dude, that is so cool. How do you even get so good at this?
Haha clicking and clinking… and some more
Bas, one quick suggestion, when you use a keyboard shortcut (different than Ctrl+C Ctrl+V) you could put in a small text in the screen that clarifies it for the people. I would have missed the Ctrl+Shift+L here if i hadn't gone back
thanks!
Good idea!
Why my power bi doesn’t show Total Labels?
Windows key + "." how did I not know this!
This is awesome! Is there any chance you can show how to do this in Tableau too?
😅barely can keep up with this channel .. but if I manage I'll do the video on howtotableau ;)
Brilliant ❤
😊
you are the best
😊 thanks for watching
wow amazing
😊😁😎👊
Bas, I can see that you are using the new contextual menus for the formatting of te visuals, truth be told, did not find them quite useful when they were launhced so I just deactivated them. Have you found any real benefit from using those in your experience or you just did the opposite of me (went on and never look back) ? cheers man!
I'm switching back at forth (some trainings I do on older versions). The new layout is a lot of clicking. But I guess its not gonna go away so think it is better to get used to it. guess it will also still improve ovr time
Will it have performance issues if huge data is there ?
What version of power bi are you using?
¡Gracias!
that's so nice!! thank you for supporting the channel! 😊
I am not able to create the dummy table i keep getting "The expression specified in the query is not a valid table expression." notification every time i try to create a dummy. Can someone help me with this!
you should insert a measure not a table
Thanks again for the great video! One question, how would you fix the Tooltip? If you hover on the part of the bar chart where it shows the ranking, it'll show a dummy measure. That doesn't look to good, do you have a way to fix that?
If you create a custom tooltip on another report page and turn it on as a tooltip for this visual, it should replace the native/automatic tooltips. you could do something as simple with the measure label and value. and try to format it to look as closely to automatic tooltips as you want (or just be creative and have fun with it and purposely make it different).
How do you get the item rank py?
Hi Bas,
This is great, one question. When I add a Dummy I can no longer have a Legend added. Is there a way to include a dummy spacer and then the actual values but retain the legend. For example I have a bar that represents multiple operating companies, I show the total revenue and have sections within the stack for each Operating company. The bar is related to each country and I want to rank the countries showing the top 10 and then include the rank development. Is that possible?
Hi Bas, could you do a video to add calendar in the slicer without any range
you can turn the range slicer off under formatting
@@HowtoPowerBI I mean a slicer with just a calendar in descending order with only one select option. The calendar cannot have both from and to date selection option as we get in the slicer using between dates option
It would help if you could share the Power BI file
see download link in the description :)
It's kind of hilarious but ever single one of your videos is is like ' Look at this new power BI feature. Let's hack it!'
Why do Microsoft impliment features that are so close, but miss the beat? Having to do hacky shit to make a half decent dashboard shouldn't be the norm.
Excellent video as always
Takk!
THANK YOU! really appreciate it 😊
Ativa as legendas em português. PLEASE!
video settings -> subtitles -> auto translate -> portugues
Thank you
Hi Bas, a small request.....
Can you please make a video on map visuals in power bi with data lable. As Power bi default visual is not allowong me to put data lable over each states.
Thanks
did a couple on maps already - maybe check out the azure maps video
cool
How to download sorce file
Like Excel sample data for this😅
there is a download link in the description to the pbix which has the data so you can follow along :)
Check description (link to download pbix inc model)
Always amazed at your content and it helps a ton as I am very early on in my PBI journey. Thanks for sharing your knowledge with us. One question about something I noticed here - multiple items in the final dummy label areas showed their previous rank as “1” and I’m assuming they were in the teens between 10-19 (or 100’s) but the label was just a little too small to show the whole number. What’s the best way to correct this, make the dummy measure 3 million so it takes up more space on the stacked bar or would we also need to do something with the label itself? Thank again!
Do i video that changes visuals between monthly data and say quarterly
yea got a few, you could use
field parameters -> ruclips.net/video/-nqEv2YXLsU/видео.htmlsi=brtQTLgelELNfrIk
automatic period selection -> ruclips.net/video/KReYWx5NXYg/видео.htmlsi=LN5bLADqW0S4EmtL ..
bookmarks -> ruclips.net/video/cYwioeHu_OU/видео.htmlsi=EM8m-Lm0-egeZRfJ
Anyone know where I can find the measures for Item Rank CY and PY for this demonstration? Timestamp ruclips.net/video/vfKxcGmw1sE/видео.html
you can have a look at the file - see download link in the description
Noob here trying to see how the measure was done to show the count going up and down...😑
Amazing work, thanks for sharing.
i had a conditional formatting on my bars and now i cant use it because i added the dummy measure
Hi Bass. Please help me.
Icons are not displayed on my chart. Only if in table visualization or September 2023 pbi version.
I tried to simply insert an icon with a unicode number without a DAX, but it only prints the unicode number and does not display the icon.
Our enterprise version is from May 2023. Could this be causing the problem or could it be a setup issue?
Thanks for your help.
Hi Bas, great works. What are the measures you used for "Item rank CY and Item Rank PY.
I used this Item Rank LM (last month)=
CALCULATE(
[Item Rank],
DATEADD(
'Date'[Date], -1,
MONTH )
)
This month : Item Rank TM =
CALCULATE(
[Item Rank],
Tablename,
ALLSELECTED('Date'[Date]))
But return #1 for all left hand side rank of my dimension.
Thanks
Same here