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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.