Forum Discussion
Do not group the same date
I have a table with two columns: date and Cost. several costs have the same date, I don't want them to be grouped by date. I want to reproduce the same table in PowerBI,
25 Replies
Hope this helps:
I'm missing something else?
Could you please check the date column whether it is summarizing?
Do i need to update the version?
Hi telesforo1969 ,
Although you choose Don't Summarize, if you have many identical duplicate values, PowerBI will still keep only one unique value. You may consider adding a new column to distinguish these identical values:
Final output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
it's not possible if i don't add another column? I would not want to add a third variable to present the repeated values. I can see from Padycosmos's solution that it's possible, except he's hidden a third column.
I have no hidden columns. Could you please check whether Do not summarize is on for the date column , and the id report column as well?
Thank you very much, but it's not exactly what I need
