Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Avoid table being marked as Measure Table in Power BI ?

We have a model in Analysis Services Tabular.
Some of the tables contain only visible measures, Power BI marks them automatically as Measures Tables and put them on top of the Fields pane.
Other (fact) tables have measures and descriptive columns, they appear between de (dimension) tables.

this makes it difficult for our end users to find the proper table, some are in the alphabetical list, others apear at the top.

Can this behaviour be switched off, so that all tables are sorted alphabetically, regardless if it only contains visible measures or not?

Status: New
Comments
v-lili6-msft
Community Support

hi

To my knowledge, this is designed by default, and it couldn't be switched off in power bi for now.

the workaround is add/unhide a column in these some of the tables contain only visible measures.

or you could submit your idea in here:

https://ideas.powerbi.com/ideas/

 

Regards,

Lin