Forum Discussion
Clustered column chart formatting
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 🙂
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.
4 Replies
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.FZOU , I visual level properties you have option for number format. Try that
Thank you for your response, but this option format the number of all columns,it didn't work by field like table for exp !
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
