Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Everyone,
I have a requirenment to edit the colors in Bar Chart. In the below attached screenshot for example if we click on red color button then all the bar charts should display red color bars. Similarly if we select green button then the bars should change to green color.
Thanks in advance.
Solved! Go to Solution.
Hi,
Not functionality that exists out of the box, but there are a couple of workarounds that might give you something similar
You could try bookmarks and buttons, in power bi desktop use ctrl-click to use buttons
Or you could use a dummy table to create a measure which control the colors of a chart
both methods are shown in this file:
example fil
Hi,
Not functionality that exists out of the box, but there are a couple of workarounds that might give you something similar
You could try bookmarks and buttons, in power bi desktop use ctrl-click to use buttons
Or you could use a dummy table to create a measure which control the colors of a chart
both methods are shown in this file:
example fil
Hi,
Thank you so much it worked...
I am also interested in your solutions. However, I can't access to your file because I am in China. I know how to do that by using bookmarks.
Could you please share a little bit more info on useing dummy table? Are you using coding to choose color?
Thanks in advance
Proud to be a Super User!
@ryan_mayu, off course,
First create a stand alone table, tableColor, with a column with the numbers 1 to 4.
On this column, create a measure like this:
Thanks for the sharing. That's very interesting. I will try that.
Proud to be a Super User!
User | Count |
---|---|
93 | |
85 | |
77 | |
68 | |
62 |
User | Count |
---|---|
112 | |
97 | |
95 | |
64 | |
58 |