question

SrikanthKoritala-4778 avatar image
0 Votes"
SrikanthKoritala-4778 asked LukasYu-msft answered

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?

sql-server-analysis-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

LukasYu-msft avatar image
0 Votes"
LukasYu-msft answered LukasYu-msft commented

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

· 4
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Actually, the tables where only measures are visible are displayed first. The alphabetical sorting then happens independently within the 'measures-only' group and within all the other tables.

1 Vote 1 ·

@AlexeiStoyanovsky: They are not showing up that way.

@LukasYu-msft : I already got this way. But, trying to avoid the prefix.

0 Votes 0 ·

@SrikanthKoritala-4778 they are for me (there's a hidden column in table z). A single visible column moves the table to the lower bucket (table b), or perhaps it could be your tabular server's version/model's compatibility level.

82844-image.png



0 Votes 0 ·
image.png (9.9 KiB)
LukasYu-msft avatar image LukasYu-msft SrikanthKoritala-4778 ·

Hi ,

Have you tested with empty table which has only measures in it? Any success on this issue?

0 Votes 0 ·
SrikanthKoritala-4778 avatar image
0 Votes"
SrikanthKoritala-4778 answered

Hi, my fact table has all dimension keys inivisible. Not all columns are calculated measures. Some of them are just numbers.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

LukasYu-msft avatar image
0 Votes"
LukasYu-msft answered

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


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.