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.
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.
Solved! Go to Solution.
@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
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
104 | |
86 | |
73 | |
66 |
User | Count |
---|---|
124 | |
113 | |
98 | |
81 | |
72 |