Get MORE out of Your BAR CHARTS in Power BI

[@HowtoPowerBI]

Learn everything I know about designing Power BI reports datatraining.io/powerbidesigntransformation

[@juanignacioXI]

Hi Bas, can u tell me please in what currency the price of the program is?

[@HowtoPowerBI]

@@juanignacioXI it is in euros

[@Aquaelus]

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 🙏

[@HowtoPowerBI]

that's really nice to hear 😊 happy you get some value out of the vids

[@diegostj]

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.

[@LokeshSowreddy]

Hey man, you are the reason behind my success. I always look into your videos before starting my work.

[@HowtoPowerBI]

that's awesome! happy to hear you are getting some value from my videos 😎👊😊

[@lorisean06]

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.

[@kyleluong9733]

Incredible work, making visuals more and more end-user friendly with each video.

[@HowtoPowerBI]

Glad you like them! 😁😊

[@titusanjorin7923]

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

[@SandeepYadav-vm5hd]

Same here

[@PhilcoCup]

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!

[@HowtoPowerBI]

Good idea!

[@MaorAviad]

You have amazing power bi content 🔋 keep it up!

[@HowtoPowerBI]

Thank you 🙌

[@Transformita]

In awe with how you come up with this stuff 💪

[@ramonillarramendi3191]

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?

[@hansgettheflammenwerfer69420]

Saving this to watch in work tomorrow!

[@HowtoPowerBI]

learning and earning at the same time 😁

[@hansgettheflammenwerfer69420]

@@HowtoPowerBI you have no idea how often I watch your videos at work to help me crack stuff

[@hirenkakkad3747]

Amazing. Your videos are very very interesting and out of box that conventionally not available on KZbin.

[@endar117]

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

[@irynavilner4533]

Amazing idea! Thank you, Bas! Wonder if there's an option to turn off the tooltip for dummy part only?

[@HowtoPowerBI]

not really, you could simply overlap an invisible shape 😁 maybe not the solution you hoped for but will work

[@irynavilner4533]

@@HowtoPowerBI Thank you! Yeah, this is not the best solution, but it definitely works!

[@rishabh1993]

Neat way to show extra info. Really creative. Keep it up. It is always great to see your creative and nifty workarounds.

[@rishabh1993]

This is directly going in our dashboard

[@HowtoPowerBI]

🎉

[@HowtoPowerBI]

Thank you very much! 😎😊

[@darshanpatel7206]

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.

[@vasilli3273]

+1

[@ariyayuva]

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)?

[@HowtoPowerBI]

check out the example file for the measure ( download link in the description )

[@SergiyVakshul]

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.

[@HowtoPowerBI]

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.

[@SergiyVakshul]

@@HowtoPowerBI Yes, sorry. I missed the part where you adjusted Dummy measure.

[@JorgeSanchez-um7io]

¡Gracias!

[@HowtoPowerBI]

that's so nice!! thank you for supporting the channel! 😊

[@МаринаПузанова-м1в]

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?

[@rokiczaaa]

Thanks to youtube suggested films panel I found this channel. Your movies show me answers before I ask questions :D Thanks :D

[@zsoltszihalmi6170]

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.

[@samerhakim994]

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.

[@miguelbardales7688]

Hi, wondering if you have the video explaining how to calculate the rank of the previous month

[@OmbaWemaluwa-n2k]

can you please explain how you got the "ITEM RANK PY" AND "CY"?

[@Amaszonas-x4g]

Thank you very much for sharing your knowledge with the community

[@JohnKleinmann]

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?

[@faryalshahabuddin9870]

Hello Bas, is there any way we can show legend only when a vlaue is selected in slicer

[@truptidahiphale7586]

Hi Bas, can we add extra labels to clustered bar/column chart?

[@karthikdevineni9608]

Hi Bas, could you do a video to add calendar in the slicer without any range

[@HowtoPowerBI]

you can turn the range slicer off under formatting

[@karthikdevineni9608]

@@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

[@bekbolots9634]

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"

[@zainuddindjafar]

Please show key to show icon thanks

[@HowtoPowerBI]

windows + . (period)

[@zainuddindjafar]

@@HowtoPowerBI thanks u

[@michaelb3254]

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?

[@JujutsuAnbu]

This is awesome! Is there any chance you can show how to do this in Tableau too?

[@HowtoPowerBI]

😅barely can keep up with this channel .. but if I manage I'll do the video on howtotableau ;)

[@Westrackted]

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?

[@lorisean06]

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).

[@Sebasalemann]

What version of power bi are you using?

[@plucks86]

This is too great. Love it. More videos like these.

[@MrMiguelGES]

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.

[@Slate-Mate]

Will it have performance issues if huge data is there ?

[@MD-kv2gc]

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.

[@HowtoPowerBI]

It changed between the videos :) so now you can use unichars

[@geineralbertomejiagarzon4034]

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?

[@andrewhamilton7475]

As always, fantastic video. Always got new tips to show my team at work!

[@mercedesiacuzzi7767]

Amazing! Very creative!

[@danielcarnaval5595]

Amazing skills! Thank you very much for sharing such great information.

[@scramiro1]

I love how you hack visuals!

[@rlds07]

Amazing work, thanks for sharing.

[@PhilcoCup]

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!

[@HowtoPowerBI]

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

[@tubeitz]

You are another level mate, thank you!

[@marcinkasierski1462]

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

[@putrigilang1516]

How do you get the item rank py?

[@AyeTee01]

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?

[@__HumanBeing]

Usefully brilliant as usual.

[@HowtoPowerBI]

Thanks you for watching! 😊

[@Blee48]

Loving the videos

[@reinaldoc.]

Beautiful

[@HowtoPowerBI]

Thank you 😊

[@ChenGrosman]

i had a conditional formatting on my bars and now i cant use it because i added the dummy measure

[@jecwonch]

This is really nice! Most of the time I use a matrix when I want to achieve something like this.

[@HowtoPowerBI]

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

[@shahzadkheros]

simple and amazing!

[@brettwilson3795]

Very impressive, a better alternative to tooltips especially with new PBi users

[@AlejoSG]

Another great video! Thank you!

[@HowtoPowerBI]

thanks for watching again!! 😊

[@wilconagtzaam587]

Great as always, thank you Bas!!

[@HowtoPowerBI]

thank you so much Wilco!!!

[@vasubabus]

Awesome Work 👌👌

[@unnikrishnansanthosh]

awesome ! thank you for sharing

[@HowtoPowerBI]

Glad you liked it!

[@Angeldsz24]

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!

[@HowtoPowerBI]

you should insert a measure not a table

[@saadiqmoose5738]

brilliant, very useful vid, thank you for sharing.

[@HowtoPowerBI]

Glad it was helpful! thanks for watching 😊

[@OScarValero83]

This is freaking awesome! Thanks a lot!!!

[@HowtoPowerBI]

Glad you like it!

[@sanumpzha]

Much appreciated for these design tweaks 🎉🎉

[@HowtoPowerBI]

Glad you like them! 😊😎

[@geirberge8971]

Takk!

[@HowtoPowerBI]

THANK YOU! really appreciate it 😊

[@pawewrona9749]

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.

[@HowtoPowerBI]

Great suggestion! let me give that also a try and see how the end visuals compare

[@pawewrona9749]

Awesome!

[@plucks86]

Why my power bi doesn’t show Total Labels?

[@josefedericopresno6668]

Another great and useful video, I was just expecting this functionality. Thanks again, Bas. You are a Master!

[@HowtoPowerBI]

Glad you liked it! 😊😁

[@alicedwonderland7733]

Bas, you're magic!

[@PavanKumar-vi7hd]

Hi Bas Amazing video

[@spilledgraphics]

Amazing, amazing, amazing!

[@zitta109]

is something changed? I can not add moe than 1 field to the X axis.... Anyone, pls?

[@MukeshSingh-cw5hr]

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

[@HowtoPowerBI]

did a couple on maps already - maybe check out the azure maps video

[@huyhoangnguyen7465]

Amazing I can apply DAX Skils to Dynamic it

[@HowtoPowerBI]

😎👊

[@natsarev]

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)

[@HowtoPowerBI]

project is already half done before you even started 😉😁

[@imxltf]

Dope! Thanks master 🙏🎉

[@HowtoPowerBI]

😎👊😊

[@tuchu0103]

really think out of the box :D

[@ernests4066]

Men u re na artist, so damn cool

[@HowtoPowerBI]

Happy 😃 you like it

[@darshanapatel1260]

It would help if you could share the Power BI file

[@HowtoPowerBI]

see download link in the description :)

[@japanese2811]

Dude, that is so cool. How do you even get so good at this?

[@HowtoPowerBI]

Haha clicking and clinking… and some more

[@naimishgohil9896]

Nice Trick

[@delidolux]

good job👌

[@chandrasekhar1883]

Creativity thinking appreciate🙏

[@HowtoPowerBI]

Thanks a lot 😊

[@mathaem]

Love it !

[@HowtoPowerBI]

yey 🎉

[@SandeepYadav-vm5hd]

How to create item rank CY and items rank PY By the way Your videos are amazing 🤩

[@RAJ-sk4fp]

How to download sorce file Like Excel sample data for this😅

[@HowtoPowerBI]

there is a download link in the description to the pbix which has the data so you can follow along :)

[@HowtoPowerBI]

Check description (link to download pbix inc model)

[@wojpaw5362]

wow amazing

[@HowtoPowerBI]

😊😁😎👊

[@Fariti-d1q]

Amazing 🎉❤

[@egbertdejong6377]

Awesome!

[@lionellawrence5798]

Like Vivek Ramaswamy says, if the pack runs in one direction, start running towards the opposite direction

[@HowtoPowerBI]

which direction am I running 😁 ?

[@lionellawrence5798]

@@HowtoPowerBI omg 🤣 instead of replying to minority mindset clip, i replied here. Sorry mate😅 love your work

[@HowtoPowerBI]

​@@lionellawrence5798 lol 😂at least I know now who Vivek Ramaswamy is ;)

[@nitheshn7019]

Thanks Bas

[@regiscarneiro9032]

Ativa as legendas em português. PLEASE!

[@HowtoPowerBI]

video settings -> subtitles -> auto translate -> portugues

[@regiscarneiro9032]

Thank you

[@itchy5135]

this is amazing but it also sounds like something Microsoft can easily add in as a built-in feature. Maybe in due time...

[@HowtoPowerBI]

let's hope they do

[@sarveshdeshpande1772]

Brilliant ❤

[@HowtoPowerBI]

😊

[@TimWallace1978]

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!

[@tarekhusam]

you are the best

[@HowtoPowerBI]

😊 thanks for watching

[@nautiyal6391]

Bro playing with power bi like a toy