Dynamic bar chart doesn't scale for all measures

[Anonymous]

Hello everyone,

Wondering if anyone knows how to solve the following:

I have a drop down list of measures.  Based on the measure that the user selects a column bar chart is populated with the data for that measure.  The Y column has start, end, and display units set to 'auto.'   Most of them appear fine, however there are 2 measures which don't have much variation (maybe 5% difference between the best and worst performer) that the scale doesn't show the difference at all.

Is there a way to better magnify the differences where it's relevant without hardcoding the ranges since the ranges vary between the measures?  Thanks for your help

Here's an example of one of the measure where it's hard to see the variation and I'd like to be able to magnify it

[v-piga-msft · Accepted solution]

Hi @Anonymous ,

By my tests and research, I'm afraid that there is no better way for us to let the range to be more obviouse between the measures in the bar chart other than you set the Y axis manually.

Best Regards,

Cherry

[Anonymous]

FYI - for the 2 meausures that had low variation (results all hovered between 95% - 99%) I multiplied the results by 100 but that didn't change the visual at all.  Looks like it's an issue