Skip to main content
Microsoft Idea

Power BI

Needs Votes

Auto Display Units Should Dynamically Change Granularity

Vote (21) Share
Andrew Cason's profile image

Andrew Cason on 24 May 2021 15:38:50

When auto is selected for display units, the granularity should automatically change to best suite the size of the data.

For example, we often have charts that have numerical ranges from the millions to thousands. In our previous BI software, it would automatically switch between showing 2.1m and 200k where as Power BI shows this as 2.1m and 0.2m.

This makes the values unnecessarily difficult for our end users to consume.

Comments (2)
Andrew Cason's profile image Profile Picture

Jonah Heng on 24 Jan 2024 21:32:30

RE: Auto Display Units Should Dynamically Change Granularity

Issue still remains today, management is still not impressed. Considering switching to Tableau since this issue causes reports to look very unprofessional.

Andrew Cason's profile image Profile Picture

Lisa Cuscuna on 03 Jun 2021 18:51:14

RE: Auto Display Units Should Dynamically Change Granularity

Agree 100%. This is causing an real issue for our end-users. One example - line chart for $191,689 is showing $0M instead of $192K. Management was not impressed.