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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Anonymous
Not applicable

Table changed to Measure icon

Hi everyone!

 

I don't know how, but a table that a I have in my model changed to an Measure icon.

 

Sin título.png

 

How can I change this and how could it happen?

 

Thanks in advance.

9 REPLIES 9
parry2k
Super User
Super User

This is weird. What is your data source?



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

If your data source is analysis services then Measures folders will show as "Measure" icon. I think that what it is? I believe your dimensions icon looks like a regular table icon, correct?



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Anonymous
Not applicable

Hi @parry2k. Thanks for your reply.

 

In this particular case, for this table, the data source is an Excel document. Yes, the dimensions are shown with the standard table icon.

 

It is really wierd, because when I just started this report, the initial icon was the known table icon, as ussual. Suddenly it changed to a measure icon. I don't really know why.

Very interesting, would like to know what happened here?

 

Do you have pivot table in excel?



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Anonymous
Not applicable

It's not that it doesn't let me work, but it is really annoying that things like this happen with no reason.

@Anonymous

 

I guess you import Excel Workbook Content into Power BI Desktop. Since your workbook contains a model already, it supposes to have a similar measure group folder which is displayed with a sigma symbol in Excel.

 

3.PNG

 

This folder will appear in a calculator icon in Power BI Desktop.

 

4.PNG

 

Regards,

Anonymous
Not applicable

Hi @v-sihou-msft. Thanks for your reply.

 

The original data source, the Excel document, has only a few columns with data. After imported that data, a table was created with those columns, all under a table icon. After working a lot with the data, adding calculated columns and measures, the original table icon changed by itlself to a measure icon.

I hope someone else can share if they seen this and how they fixed it?



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Anonymous
Not applicable

Hi @parry2k. No, I do not have a pivot table. This same thing, just happened againt to an other table. I starting to think that maybe it has to do something with the count of mesasures that you have under that table. It's just a guessing.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.