Forum Discussion

BAIME's avatar
BAIME
New Member
4 years ago
Solved

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): 

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): 

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.