formatting

[dbtornell]

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

[dbtornell]

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

[dbtornell]

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

[dbtornell]

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

[dbtornell]

Bump

[RMDNA]

Hi @dbtornell,

Please keep in mind that this is a community forum, so it usually takes a while to get your question answered, especially a more complicated one like this. Bumping your topic every hour won't help.

[dbtornell]

Bump. Can someone please help me with this?

Sincerest Thanks,

David

[dbtornell]

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.

[dbtornell]

Bump

[v-juanli-msft · Accepted solution]

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.

Reference here.

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