cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Advocate II
Advocate II

Dynamic bar chart doesn't scale for all measures

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

Capture.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Resident Rockstar
Resident Rockstar

Hi @luketerry ,

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

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Resident Rockstar
Resident Rockstar

Hi @luketerry ,

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

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

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

Helpful resources

Announcements
November Update

Check it Out!

Click here to read more about the November 2020 Updates!

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform October Community Highlights

Check out the top community contributors across all of the communities

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors