This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(76.8, 28.000000000000004%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
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?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 9%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELY%3C/text%3E%3C/svg%3E)
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
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(32, 95%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
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.
@Alexei Stoyanovsky : They are not showing up that way.
@Lukas Yu -MSFT : I already got this way. But, trying to avoid the prefix.
@Srikanth Koritala 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.
Hi ,
Have you tested with empty table which has only measures in it? Any success on this issue?
Hi, my fact table has all dimension keys inivisible. Not all columns are calculated measures. Some of them are just numbers.
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