Forum Discussion

nanma94's avatar
nanma94
Helper III
7 years ago

Table/Matrix field formatting doesnt have auto

I use matrix visual in my report. When I show to president, I want the $ values to show in millions while when I show the same report to a sales rep, the $ value in thousands makes the most sense. However, I find both table and matrix format options dont have AUTO as part of the field format display units. This makes me creating multiple versions of Power BI file just to address different levels of reporting needs. 

 

Do I have any other better options?

 

 

Thank you!

NM

Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi nanma94,
    PBI wouldn't know if you'll show your report to president or not.
    Solution is to use a disconnected table and to create a measure to achieve your necessity.

    See next images with my proposal.
    Tell us if work for you.

     

    Disconnected tables

    Dashboard no selected measure

     

    President measure selected

    • nanma94's avatar
      nanma94
      Helper III
      7 years ago

      Thank you for marking it up Anonymous ! It gives me some great ideas.

       

      My report has row level security so I do check who loggs in. Maybe I can determine from their security role whether to show in million or thousands. 

       

      I am just wondering why table/matrix doesnt give this auto option as its available for card. 

       

      NM

      • v-piga-msft's avatar
        v-piga-msft
        Resident Rockstar
        7 years ago

        Hi nanma94,

         

        You could submit your idea in Power BI ideas Forum.

         

        For your scenario, I will suggest your could create a measure to show the value with millions or thousands dynamically when filter who logs in.

         

        Best Regards,

        Cherry

  • tamnm1601's avatar
    tamnm1601
    Advocate I
    3 years ago

    Hello,

     

    This topic was in 2018 and I got the same issue. I'm wondering why MS haven't put it into action at all.

    The 'Auto' number formating should be the very basic feature in table and matrix.