formatting

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