Clustered column chart formatting

[FZOU]

 Hello everyone,

Any one have an idea on how to change just the display unit of C on Thousands (K) and let A,B on Millions(M) like they are already !

Thank you 🙂

[v-henryk-mstf · Accepted solution]

Hi @FZOU ,

Currently Power Desktop cannot be implemented in Clustered column chart format unit, because after format is used, the Number type will be converted to Text type and cannot be changed. It cannot be placed in the value of the Clustered column chart.

But according to your requirements, I have done the following tests for reference:

Create three measures to find the values of a, b, and c in the ID column. Then put the measure into the Values of the Clustered column chart, and set the units of different measures in the Data labels of Format in turn.

If the problem is still not resolved, please provide detailed error information and let me know immediately, looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mahoneypat]

Your best option might be to make a measure to be used in your tooltip, using a threshold of 1M and return one of two formats using the FORMAT measure.  That way, users could see the value when they hover.

Pat

[amitchandak]

@FZOU , I visual level properties  you have option for number format. Try that

[FZOU]

Thank you for your response, but this option format the number of all columns,it didn't work by field like table for exp !