Forum Discussion

FZOU's avatar
FZOU
Helper IV
5 years ago
Solved

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 🙂
Need Help
  • v-henryk-mstf's avatar
    v-henryk-mstf
    5 years ago

    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.

v-henryk-mstf's avatar
v-henryk-mstf
Community Support
5 years ago

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.