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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
BAIME
New Member

Do not summarize table with multiple text columns

For my report, I've made a graph in which you can see the total number of leads. This is all fine and we get the correct total count. 

 

If the user wants to look at the details of these leads, they go to another page where they get the total table with all details. 

This works perfect, only if there are similar entries, the table summarizes this data automatically on date (date and time of entry are the same). 

 

What we now get (example in Dutch): 

Current situation.JPG

Where you see that on the 17th of September there are three rows here and they are shown in one single line of the table. 

 

What we want to get (this is a picture of the table in Power BI): 

wenselijk.JPG

Normally this would work if we set all columns on 'Do not Summarize' & 'Show items with no data', but for this table (with only text and one date column) it does not work like that. 

 

I've looked through all possible related questions here in this site, but did not found this particular question. 

Anybody knows how to solve this?

 

Thank you in advance for your kind help. 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@BAIME , duplicate rows will not be repeated(distinct or group by is applied on all visual) . You can add index column in power query and add that as not summarized column in table visual

https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@BAIME , duplicate rows will not be repeated(distinct or group by is applied on all visual) . You can add index column in power query and add that as not summarized column in table visual

https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi

Thank you for this solution, it works.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.