Showing results for 
Search instead for 
Did you mean: 
Helper III
Helper III

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!


Advocate I
Advocate I



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.



Not applicable

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 tablesDisconnected tables

Dashboard no selected measureDashboard no selected measure


President measure selectedPresident measure selected

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. 



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,


Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors