Forum Discussion
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.
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
2 Replies
- amitchandakSuper 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
- BAIMENew Member
Thank you for this solution, it works.