Value units in Bar chart and Card is showing differnt.

[rajendraongole1]

Hi all,

I have created clustered column chart & card visuals which shows different units in Y-axis with (M) and card visual with (K) as per the below snapshot.

can you please suggest why we are getting two different units in both card and bar chart?

Please suggest? is this the right approach?

suppose if we want to represent both the units in those charts. how can we achieve it?

[v-kelly-msft · Accepted solution]

Hi  @rajendraongole1 ,

Reply updated:

This is by design for now. Axis logic is slightly different than a global callout value. Axes get a format string for the axis tick interval, not the global aggregate. It must ensure the difference between ticks is noticeable in the label, and it creates its own format string and display units. For Card, a single aggregated number is used as input to Auto display units logic. Hence, different input, different output. Also, for Cartesian chart data labels, we share the axis display unit, for consistency, so they do match.

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!

[rajendraongole1]

Hi

This option i am aware of it.

thats why i am using auto mode to project the as usual values . why we are getting if we use auto mode the sowcase charts in bar chart with y axis with (m) and card visual with (k).Why the units are different in both visuals.

in card visual also it is should representing 0.92M right?  will that possible? This is the question i have .. 

Please suggest.

[v-kelly-msft]

Hi @rajendraongole1 ，

Has reported this issue,ICM:268786033.

Will keep you informed if there is any update.

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!

[goncalogeraldes]

@rajendraongole1 I am not completly sure what your question is, so maybe one of these links can provide you with help:

https://powerbidocs.com/2020/09/26/custom-display-units-in-power-bi/

https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?MessageKey=2593f8a8-...

[goncalogeraldes]

Hello there @rajendraongole1 ! In your clustered column chart, your [Sales] measure is formatted to display the values in Millions whereas in the Card visual it is formatted to display in thousands. You can edit both of these values to ensure they have the same scale in the "Format" pane in the "Data label" menu, on "Display units" option, like so:

Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!

You can also check out my LinkedIn!

Best regards,
Gonçalo Geraldes