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.
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!
Wonderful!! Thank you very much. And the technique of displaying items and pages is great. Could you please explain it a little bit further? do you have a video about that?
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
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.
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.
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?
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
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.
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.
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?
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
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)?
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?
Thanks for all the content Bas, really good. You mentioned in one custom labels video that emoticons could not be used (unicode) in the label but here you're using some... Are these just the standard code page font characters here or are there some situations when richer emoji chars can be used? Thanks again.
How can I make this work if my bar chart has a "Legend" field with a measure that categorizes the values on x-axis? When following video instructions, I can't add the dummy measure onto the X-axis, only as a "tooltip"
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?
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
@@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
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)
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
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!
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
![Noob To Max With DRAGON REWORK In Blox Fruits [FULL MOVIE]](http://i.ytimg.com/vi/LnBMOinoOvA/mqdefault.jpg)
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.
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 😎👊😊
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.
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!
Incredible work, making visuals more and more end-user friendly with each video.
Glad you like them! 😁😊
¡Gracias!
that's so nice!! thank you for supporting the channel! 😊
Wonderful!! Thank you very much. And the technique of displaying items and pages is great. Could you please explain it a little bit further? do you have a video about that?
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 🙌
Amazing. Your videos are very very interesting and out of box that conventionally not available on RUclips.
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
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
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
can you please explain how you got the "ITEM RANK PY" AND "CY"?
Takk!
THANK YOU! really appreciate it 😊
Neat way to show extra info. Really creative. Keep it up. It is always great to see your creative and nifty workarounds.
This is directly going in our dashboard
🎉
Thank you very much! 😎😊
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.
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?
Thank you very much for sharing your knowledge with the community
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!
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?
Hi, wondering if you have the video explaining how to calculate the rank of the previous month
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
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.
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.
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?
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
Hi Bas, can we add extra labels to clustered bar/column chart?
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 )
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?
Thanks for all the content Bas, really good. You mentioned in one custom labels video that emoticons could not be used (unicode) in the label but here you're using some... Are these just the standard code page font characters here or are there some situations when richer emoji chars can be used? Thanks again.
It changed between the videos :) so now you can use unichars
Amazing skills! Thank you very much for sharing such great information.
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 ;)
How can I make this work if my bar chart has a "Legend" field with a measure that categorizes the values on x-axis? When following video instructions, I can't add the dummy measure onto the X-axis, only as a "tooltip"
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).
This is too great. Love it. More videos like these.
As always, fantastic video. Always got new tips to show my team at work!
Hello Bas, is there any way we can show legend only when a vlaue is selected in slicer
What version of power bi are you using?
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
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?
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
Another great and useful video, I was just expecting this functionality.
Thanks again, Bas. You are a Master!
Glad you liked it! 😊😁
Very impressive, a better alternative to tooltips especially with new PBi users
Will it have performance issues if huge data is there ?
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
You are another level mate, thank you!
How do you get the item rank py?
Much appreciated for these design tweaks 🎉🎉
Glad you like them! 😊😎
Please show key to show icon thanks
windows + . (period)
@@HowtoPowerBI thanks u
I love how you hack visuals!
Loving the videos
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 😉😁
Amazing work, thanks for sharing.
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!
i had a conditional formatting on my bars and now i cant use it because i added the dummy measure
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
brilliant, very useful vid, thank you for sharing.
Glad it was helpful! thanks for watching 😊
Amazing! Very creative!
Bas, you're magic!
Beautiful
Thank you 😊
Usefully brilliant as usual.
Thanks you for watching! 😊
Awesome Work 👌👌
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
Great as always, thank you Bas!!
thank you so much Wilco!!!
Another great video! Thank you!
thanks for watching again!! 😊
This is freaking awesome! Thanks a lot!!!
Glad you like it!
simple and amazing!
Amazing, amazing, amazing!
Why my power bi doesn’t show Total Labels?
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!
is something changed? I can not add moe than 1 field to the X axis.... Anyone, pls?
awesome ! thank you for sharing
Glad you liked it!
Dope! Thanks master 🙏🎉
😎👊😊
Amazing I can apply DAX Skils to Dynamic it
😎👊
Creativity thinking appreciate🙏
Thanks a lot 😊
Dude, that is so cool. How do you even get so good at this?
Haha clicking and clinking… and some more
Love it !
yey 🎉
Amazing 🎉❤
Hi Bas
Amazing video
really think out of the box :D
How to create item rank CY and items rank PY
By the way Your videos are amazing 🤩
Ativa as legendas em português. PLEASE!
video settings -> subtitles -> auto translate -> portugues
Thank you
It would help if you could share the Power BI file
see download link in the description :)
Thanks Bas
good job👌
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)
Brilliant ❤
😊
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
Awesome!
Nice Trick
you are the best
😊 thanks for watching
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
wow amazing
😊😁😎👊
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!
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 ;)