Measure table is not invisible dimension table, it is create only for storing meausres, maybe you could see this and try if it works: Measure Tables in Power BI
How can I show some tables on the top in the tabular models in Power BI
Hi, I need to show Measure tables on the top and dimensions in the bottom when I connect the Power BI to the tabular model. How can I do that?
3 answers
Sort by: Newest
-
-
Srikanth Koritala 1 Reputation point
2021-04-02T11:46:17.577+00:00 Hi, my fact table has all dimension keys inivisible. Not all columns are calculated measures. Some of them are just numbers.
-
Lukas Yu -MSFT 5,816 Reputation points
2021-03-30T03:14:33.827+00:00 Hi,
Power BI arrange the tables alphabetically.So if you want to make measure tables on top, you could modity your model tables with prefix so they could show on top. For example 0 for fact tables, 1 for dimension tables.
Something like 0_measure-table-names, and 1_dimension-table-names, could make this sorting happen in Power BI.
Regards.
Lukas