Clustered Column Chart X-axis : A and B fields Y-axis: C field Legend: D field In D field i have 25 to 30 items ( like names, units, cities,... ). How to set up color for each item in the legend ( same color to be appear when we drill down/up based on A and B fields wise.
I want place legend Vertically like below at the bottom Center of any Visual Legends A B C D ( Horizontally ) Legends A B C D. Is this possible in Power BI?
Hi, thanks for your video. I'd like to add a pop up window on the head of a column in order to describe the column content. I'd like to have a popup window for each column of my table. How can I do this? Thanks
Your videos put me out of troubles. Need to do simple a dashboard for a customer demo, but I'm a backend developer 😅 Until yesterday for me Power BI was an alien language. Thank you!
Hi team Its me tauseef could you please suggest is it possible to see data by using colour like if i click on red colour data should come which people which is not working
thank you for this video - my question is similar yet different - I need to color code the equivalent of your Top 5 Claims by Type - Passenger needs to be a different color to Property rather than all values being Blue - is that possible?
Hi I have data of all the Nike locations of USA and locations of my warehouse. I wanted to plot all the locations on the map visual in power bi but i wanted the warehouse location bubble to be of 50 mile radius so I'll know how many Nike stores are within 50 miles of my Warehouse. Is there a way to change the bubble size of a particular legend??
Very Cool, I have a question outside this topic. How to connect MS Planner to be used in Power Bi? I've tried using FluentPro DataMart Cloud but it didn't work. I would like to have the tasks in MS Planner and see them in Power BI
Hi Patrick having the following issue while using legends in powerbi "repeated indices found in group by or projections". When there is no dimension in the axis pan, it goes fine. But when there is a dimension in the axis field it generates the above mentioned error.
Thank you for this video. Could you use this trick on a Stacked Column Bar Chart. I'm running the latest version of Power Bi but I do not have a fx option in the Data Colors section?
I love the idea - managed the conditional formatting in the table but my legend bars all have the same color although I followed the same steps - thoughts?
Is there a way to make this custom legend smaller? I would like it to be the same size as the default legend (small circle, text, small circle, text, etc)
Hey Patrik. Could you help me with right way to calculate dynamic 12 weeks cumulative data ( i want to show last 12 weeks data in simple scorecard heading will have Week 1 , week 2, 3,4,5, etc and every week should have cumulative data week over week. from week 13 onward the range should be week 2 to week 13, from 14 the range should be week 3 to week 14, so on.)
Thanks for putting this together, and for responding to my comment on your earlier video about conditional formatting. Mind blown! Very creative use of a "standard" visual. Cheers.
Can you please help me out to understand this code ? I'm Unable to understand the SWITCH part specially. This code is intended for creating dynamic legend. Measure = VAR StateCount = CALCULATE(DISTINCTCOUNT(Bridge[State]), ALLSELECTED(Bridge), ALLSELECTED(Legend)) VAR RegionCount = CALCULATE(DISTINCTCOUNT(Bridge[Region]), ALLSELECTED(Bridge), ALLSELECTED(Legend)) VAR LevelNumber = SWITCH( TRUE(), StateCount = 1, 3, RegionCount = 1, 2, 1) RETURN CALCULATE(SUM(Fact[Population]), Legend[Level] = LevelNumber)
Hey Patrick, Great Video, but my custom theme colors aren't coming through! I've defined them all in the theme as HEX colours, and now the Data Colors Formatting pane is throwing this error: "We found a value we don't recognize for Default Color." and the Default Color formula area is throwing this "help": "To fix the problem use HEX codes or use the supported list of CSS colors." I thought the theme WAS using HEX codes if I defined them in RGB / HEX in the theme JSON?
Nevermind, you created a column in the other video for the conditional formatting, and that's the column you used in your formula... Got it! Link to other video for posterity: ruclips.net/video/FgnPIaxpdJ0/видео.html
This actually spawns a new question. Can I access the Theme information from a DAX formula in order to create my colour column. Instead of in your example specifying "Red", "Green", "White", etc... I'd like to specify "Theme Colour 1", "Theme Colour 6", "Theme Colour 2", etc. in the dimension table that defines my legend colours.
Are you looking for the actual DAX? or how to create a calculated column in general? docs.microsoft.com/power-bi/transform-model/desktop-tutorial-create-calculated-columns
Are you able to show a video on how to sort legends dynamically based on value, for a bar chart? Considering we have the axis as years, the values as budget, and the legend as 40+ categories, this seems to be a fairly complicated process and am wondering if there is a simple(r) way to achieve this. Thank you, love your videos!!!
Thank you so much!!! This was a huge help because I was trying to figure out how to add this very setup to a graph. I am a new user and trying to do it without training! I definitely subscribed.
Love the concept, now i need to fit this into my reporting. From London, UK. Hope you guys are enjoying the Power Platform World Tour in Houston. Peace...
Almost!. When I look at the tool tip for this I get the measure I used (you called yours legend) included as 1 for each colour/category. So maybe next time how do we remove lines from the simple tool tip? (or have you done that already). I hope it doesn't involve creating a whole page for the remote tool tip.
This is an ok solution for less complicated dashboards, but if I need to do this to every chart that I want to limit what gets listed in the legend...oi vey.
"It is the concept", nicely put Patrick! thanks for sharing this Legend Trick!
You are welcome. Thanks for watching! 👊
Thank you for your video, but I have a question how do you get the claim status color?
Clustered Column Chart
X-axis : A and B fields
Y-axis: C field
Legend: D field
In D field i have 25 to 30 items ( like names, units, cities,... ). How to set up color for each item in the legend ( same color to be appear when we drill down/up based on A and B fields wise.
Hi, thanks for great video! I didn´t get how you created the Claim status that you put on the Axis, have you shown that in a previous video?
I want place legend Vertically like below at the bottom Center of any Visual
Legends A B C D ( Horizontally )
Legends A
B
C
D. Is this possible in Power BI?
Hi, thanks for your video. I'd like to add a pop up window on the head of a column in order to describe the column content. I'd like to have a popup window for each column of my table.
How can I do this? Thanks
How to add a legend for Matrix Visual where the fonts are conditionally formatted based on their values in a certain column?
Your videos put me out of troubles. Need to do simple a dashboard for a customer demo, but I'm a backend developer 😅 Until yesterday for me Power BI was an alien language. Thank you!
Hi team Its me tauseef could you please suggest is it possible to see data by using colour like if i click on red colour data should come which people which is not working
thank you for this video - my question is similar yet different - I need to color code the equivalent of your Top 5 Claims by Type - Passenger needs to be a different color to Property rather than all values being Blue - is that possible?
Hi. Please help. Can we do this on Pie or Donut charts?
Dude, you are the LEGEND.
Thank you! 👊
Hi
I have data of all the Nike locations of USA and locations of my warehouse. I wanted to plot all the locations on the map visual in power bi but i wanted the warehouse location bubble to be of 50 mile radius so I'll know how many Nike stores are within 50 miles of my Warehouse. Is there a way to change the bubble size of a particular legend??
Very Cool, I have a question outside this topic. How to connect MS Planner to be used in Power Bi? I've tried using FluentPro DataMart Cloud but it didn't work. I would like to have the tasks in MS Planner and see them in Power BI
Hi Patrick having the following issue while using legends in powerbi "repeated indices found in group by or projections". When there is no dimension in the axis pan, it goes fine. But when there is a dimension in the axis field it generates the above mentioned error.
THANKS!!!! Great solution to the limitations of legends in BI!
Good stuff, Patrick! I'm at the Houston PPWT and it took me a moment to realize it was you during the morning kickoff. I'll stop by to say hello.
Love this guy! Always makes everything look easy. Love that he left the Alexa/Siri snafu in there.. so funny.
Thank you for this video. Could you use this trick on a Stacked Column Bar Chart. I'm running the latest version of Power Bi but I do not have a fx option in the Data Colors section?
Hey Patrick,
I think tree chart with labels is another effective way to do this.
Yup. Different ways to do it for sure! 👊
Hi Patrick, thanks a lot for this video! Can you please make a video about custom order of data legend?
This is an awesome idea. 👍👍👍👍👍 Apply to your method, I used Treemap visual instead to have the same legend smaller and easier to adjust.
how did you do that client status color patrick
im wondering about this too.im stuck here
I love the idea - managed the conditional formatting in the table but my legend bars all have the same color although I followed the same steps - thoughts?
Brilliant idea !!!
Loved the guest appearance from Alexa as well
Thank you! 👊
Is there a way to make this custom legend smaller? I would like it to be the same size as the default legend (small circle, text, small circle, text, etc)
Hey Patrik.
Could you help me with right way to calculate dynamic 12 weeks cumulative data ( i want to show last 12 weeks data in simple scorecard heading will have Week 1 , week 2, 3,4,5, etc and every week should have cumulative data week over week. from week 13 onward the range should be week 2 to week 13, from 14 the range should be week 3 to week 14, so on.)
Thanks for putting this together, and for responding to my comment on your earlier video about conditional formatting. Mind blown! Very creative use of a "standard" visual. Cheers.
Can you please help me out to understand this code ?
I'm Unable to understand the SWITCH part specially.
This code is intended for creating dynamic legend.
Measure =
VAR StateCount = CALCULATE(DISTINCTCOUNT(Bridge[State]), ALLSELECTED(Bridge), ALLSELECTED(Legend))
VAR RegionCount = CALCULATE(DISTINCTCOUNT(Bridge[Region]), ALLSELECTED(Bridge), ALLSELECTED(Legend))
VAR LevelNumber =
SWITCH(
TRUE(),
StateCount = 1,
3,
RegionCount = 1,
2, 1)
RETURN CALCULATE(SUM(Fact[Population]), Legend[Level] = LevelNumber)
Awesome. I would love to have value, percentage and series name in the legend!
Awesome idea! Thinking outside of the box to re-purpose existing visuals to make something custom. Thanks for sharing!
Thanks for watching! 👊
Mind-blowing. Thank you so much
Hey Patrick,
Great Video, but my custom theme colors aren't coming through! I've defined them all in the theme as HEX colours, and now the Data Colors Formatting pane is throwing this error:
"We found a value we don't recognize for Default Color."
and the Default Color formula area is throwing this "help":
"To fix the problem use HEX codes or use the supported list of CSS colors."
I thought the theme WAS using HEX codes if I defined them in RGB / HEX in the theme JSON?
Nevermind, you created a column in the other video for the conditional formatting, and that's the column you used in your formula... Got it!
Link to other video for posterity:
ruclips.net/video/FgnPIaxpdJ0/видео.html
This actually spawns a new question. Can I access the Theme information from a DAX formula in order to create my colour column. Instead of in your example specifying "Red", "Green", "White", etc... I'd like to specify "Theme Colour 1", "Theme Colour 6", "Theme Colour 2", etc. in the dimension table that defines my legend colours.
Nice hack... Thanks guys. You guys are amazing, always !!
Thanks! 👊
Great Patrick... Thanks for sharing...
Holy moly.. You are amazing guys :) Love from India
Thank you for the kind words! 👊
Not what I was expecting at all, but a great method.
Where can I get that shirt?!
Like ur videos, it really helps to understand the logic/calculations so easily.
Hi All, I couldn't understand the cal column "Claim status colour ", how he created it. Can someone help?
Are you looking for the actual DAX? or how to create a calculated column in general? docs.microsoft.com/power-bi/transform-model/desktop-tutorial-create-calculated-columns
Are you able to show a video on how to sort legends dynamically based on value, for a bar chart? Considering we have the axis as years, the values as budget, and the legend as 40+ categories, this seems to be a fairly complicated process and am wondering if there is a simple(r) way to achieve this. Thank you, love your videos!!!
Thats awesome! Thanks for sharing.
Thank you! 👊
Thanks. Simple, SImple!
Thank you so much!!! This was a huge help because I was trying to figure out how to add this very setup to a graph. I am a new user and trying to do it without training! I definitely subscribed.
Great concept Patrick! Only thing I can say - it's bananas! Keep up great work Guys :)
Absolutely love your content. Thank you for this, I really needed it!
Love the concept, now i need to fit this into my reporting. From London, UK. Hope you guys are enjoying the Power Platform World Tour in Houston. Peace...
how can you create custom legend in a filled map?
Amazing concept 👌👌
How can I not show blank in my legend actually I created a table based on the data value like Resignation = volunteer and Retirement = Involunteer
Great job!
this legend applies for matrix chart???
Exactly what I wanted
Almost!. When I look at the tool tip for this I get the measure I used (you called yours legend) included as 1 for each colour/category.
So maybe next time how do we remove lines from the simple tool tip? (or have you done that already).
I hope it doesn't involve creating a whole page for the remote tool tip.
Nice, thanks!
Thank you! 👊
can you hide legend label when no data exist in a chart in power bi
Legendary 😃
Thank you very much! 👊
Excellent
How to put multiple coloumns in one slicer.
Mmm maybe we can do the legend filters the visual , just thinking a loud
It's just a table, so it should work.
those squares were too big, dint met my requirements. ended up creating my own using shapes and textboxes :(
You great !
Wow!
LOL I just watched that video and thought the same thing...LOL
You are incredibly super
Thanks! 👊
genius
Appreciate that! Thanks for watching 👊
this video should have all the steps, to be honest.
This is an ok solution for less complicated dashboards, but if I need to do this to every chart that I want to limit what gets listed in the legend...oi vey.
Of course. It always depends :)
Hacked