Forum Discussion
formatting
Hello,
I want to create a cluster chart that shows, by distribution center, if target numbers are being reached on a monthly basis. I want to make my x-axis my distribution centers, my legend the months, and the value the percentages achieved but that hasn't created the visual I want. I want there to be 12 bars by the end of the year, representing the percentages reached per month, per x-axis point which are the distribution centers; there should be 12 bars per distrbution center. Also I want the bars to show the exact values when you click on them but I want them to be a static height and color for a certain range. For example if the percent hit is between 50-100 percent, lets say 89 percent, the bar would be 75% and the color yellow on the graph but when you scroll over it it would tell you 89 percent. Is this possible? I am looking for a step by step an detailed solution. If any clarification is need lmk. I have attached below what the data and I want to know how format it, the way I described above, in power bi.
Thanks,
David
Hi dbtornell
make my axis my locations, my legend the months, and the value the percentages achieved
In Query editor, select month columns from “January” to “December”, and select “Transform”->”Upvoit columns”,Then rename columns
In Report View, add columns to Clustered Column chart
I want the bars to show the exact values when you click on them but I want them to be a static height and color for a certain range.
When you click on a bar, the bar would highlight and others would fade in color.
One workaround is to add a report tooltip on this visual.
For example if the percent hit is between 50-100 percent, lets say 89 percent, the bar would be 75% and the color yellow on the graph but when you scroll over it it would tell you 89 percent.
I’m afraid it is not possible.
Best Regards
Maggie
7 Replies
Hello,
I want to create a a cluster chart that shows, by distribution center, if target numbers on being reached on a monthly basis. I was thinking I need to make my axis my locations, my legend the months, and the value the percentages achieved. Also I want the bars to show the exact values when you click on them but I want them to be a static height and color for a certain range. For example if the percent hit is between 50-100 percent, lets say 89 percent, the bar would be 75% and the color yellow on the graph but when you scroll over it it would tell you 89 percent. Is this possible? I am looking for a step by step an detailed solution. If any clarification is need lmk. I have attached below what the data and I want to know how format it, the way I described above, in power bi.
Thanks,
David
At the end of the year each point on the x-axis should have twelve bar values corresponding to the 12 months. I alsow ant those 12 bars, per each plant, to be color coded and static in height based on certain target criteria.
Bump
Bump. Can someone please help me with this?
Sincerest Thanks,
David
Bump
Hi dbtornell
make my axis my locations, my legend the months, and the value the percentages achieved
In Query editor, select month columns from “January” to “December”, and select “Transform”->”Upvoit columns”,Then rename columns
In Report View, add columns to Clustered Column chart
I want the bars to show the exact values when you click on them but I want them to be a static height and color for a certain range.
When you click on a bar, the bar would highlight and others would fade in color.
One workaround is to add a report tooltip on this visual.
For example if the percent hit is between 50-100 percent, lets say 89 percent, the bar would be 75% and the color yellow on the graph but when you scroll over it it would tell you 89 percent.
I’m afraid it is not possible.
Best Regards
Maggie
