cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Table changed to Measure icon

‎01-16-2017 08:22 AM

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.

Labels:
Message 1 of 10
4,817 Views
0
9 REPLIES 9
parry2k
Super User
Super User

‎01-16-2017 03:28 PM

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.

Message 2 of 10
4,801 Views
0
parry2k
Super User
Super User
In response to parry2k

‎01-16-2017 03:31 PM

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.

Message 3 of 10
4,800 Views
0
Anonymous
Not applicable
In response to parry2k

‎01-17-2017 03:11 AM

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.

Message 4 of 10
4,785 Views
0
parry2k
Super User
Super User
In response to Anonymous

‎01-17-2017 09:15 AM

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.

Message 5 of 10
4,777 Views
0
Anonymous
Not applicable
In response to parry2k

‎01-17-2017 10:09 AM

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

Message 7 of 10
4,771 Views
0
v-sihou-msft
Microsoft
Microsoft
In response to Anonymous

‎01-18-2017 01:09 AM

@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,

Message 9 of 10
4,756 Views
0
Anonymous
Not applicable
In response to v-sihou-msft

‎01-18-2017 06:51 AM

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.

Message 10 of 10
4,749 Views
0
parry2k
Super User
Super User
In response to Anonymous

‎01-17-2017 10:46 AM

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.

Message 8 of 10
4,770 Views
Anonymous
Not applicable
In response to parry2k

‎01-17-2017 10:07 AM

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.

Message 6 of 10
4,774 Views
0

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

View All
Top Solution Authors
View All