Forum Discussion

nanma94's avatar
nanma94
Icon for Helper III rankHelper 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. Ho...
Need Help
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
Icon for Helper III rankHelper 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
    Icon for Resident Rockstar rankResident 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