Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

KPI Matrix Number Formatting

Hey Guys!   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 s...
Need Help
v-yuta-msft's avatar
v-yuta-msft
Community Support
7 years ago

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

     

    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

    • v-yuta-msft's avatar
      v-yuta-msft
      Community Support
      7 years ago

      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.