Why is my Table not changing to a Measures Table?

[HamidBee]

Hi All,

This is not a huge deal but I'm just curious as to why the symbol here isn't changing to show that it's a measures table. I collapsed the filed and expanded it again. I even closed Power BI and relaunched it again. I have the latest Power BI so I think that they've just changed it when compared to previous ones. Please see below:

Compared to what I was hoping to get:

Any help is appreciated. Thanks.

 

 

[v-jayw-msft · Accepted solution]

Hi @HamidBee ,

How did you create the table? I created a table use the Enter Data feature and enter only one row with a value "1". After that I created a measure under the table and delete the initial column then the table became a measures table. I'm using December 2021 version of Power BI Desktop.

Best Regards,

Jay

[HamidBee]

Thank you it worked! Before I was creating a new table instead of entering data. So prior to knowing this I would have a new table called "x" and with a column titled "column" and no value. This is what happens when I create a new table, there is no option to delete the table:

It works when I click "enter data" and delete the table in that way but it doesn't work when I delete a table after I click "create a table". It doesn't even give me an option to delete the table in this way.

Thank you,

Hamid

[ALLUREAN]

Not sure if this is because of a PBI version (latest is December 2021), but you can try to delete the Measures table, create it again, hide the column, it will dissapear, then create measures or just move another measure into the table and should shows up

Appreciate your Kudos !!!

https://allure-analytics.com/

[HamidBee]

Honestly I tried this again and again but it doesn't work. Thanks anyway

[PaulDBrown]

What PBI version are you on? In previous versions (can't remember from which) you had to hide the field pane (click on the arrow at the top of the pane) and restore it for the change to happen

[HamidBee]

I have version: Version: 2.99.862.0 64-bit (November 2021). I have already tried collapsing the fields pane and opening it again, same issue. I'm wondering whether it just is this way on the new versions of BI.

[amitchandak]

@HamidBee when all columns are hidden and there are only measures in the table, it should show that icon. Strange, you have only one measure and it not showing that

[HamidBee]

I tried increasing the number of measures. Same answer. Thankfully it wouldn't affect anything but I was just curious.