Forum Discussion
KPI Matrix Number Formatting
Anonymous,
I am using the KPI Matrix within PowerBI. If you got to "Current Value", there is the possibility to set a number formatting.
I really didn't get the way of how this works. Is there somewhere a documentation for this?
I want to get the following 2 formats: first one: 17,3 Mio and the second one: 74,44 % with only two numbers after the comma!
Could you clarify more details and share some sample data for further analysis?
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
That is what you see in the "Curent Value" column at the moment.
And there is this format field:
What do I have to enter here, so that the value "0,747" is displayed as "0,75" or as "74,77 %".
Onther wish would be to format a Number "15549872" as "15,54 Mio".
Is this possible?
BR
Anonymous,
You may change the data format via Modeling-> Format, not the Format pane of KPI matrix chart. In addtion, if there are format not support in power bi. I' afraid you should create a calculate column or measure to generate a formta manually using DAX such as concatenate.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.