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 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!

 

I hope you can help me! ;)

 

BR

Need Help

4 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Icon for Community Support rankCommunity 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
        Icon for Community Support rankCommunity 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.

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

    Anonymous,

     

    Have you solved your issue by now? If you have, could you please help mark the correct answer to finish the thread? Your contribution will be much appreciated.

     

    Regards,

    Jimmy Tao