Forum Discussion
Table doesn't display duplicate lines
Hi guys,
I have 5 data lines in the data table and I would like to display them all. But with columns that I choosen for the table, the contain is not different between lines. So, the table displays only 2 lines like following :
A | B | C
line 1) x | y | z
line 2 ) l | m | n
It should display 3 lines of line 1 and 2 lines of line 2. I know that Power BI doesn't display duplicate line but I have to and the data will be different later after some refresh.
I thought about creating an index column and put it on the table to have all 5 lines but we prefer to avoid this solution for some reasons
Do someone knows how can I do ?
Thank you very much !
Hi, Anonymous
I think you should understand that Power BI removes duplicate rows from a table by default. This is due to Power BI being an aggregation tool. The only way to display duplicate lines in your table chart is to make them different in at least one field. Therefore, adding a column is unavoidable. If you think that it will lead to the user being confused when exporting the data. You can just add an index column in the Power Query editor to give them a unique ID, like this:
And you can get what you want.
You can download my test pbix file here
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
Hi, Anonymous
According to your description and sample data, I can understand what you want to get, you want to show the duplicate lines which have the same value in the table chart, right?
You can try my steps:
This is my tested data based on your description and the output when I placed them into a table chart:
- I created a calculated column:
Index = RAND()- I placed the column into the table chart and set the field formatting like this:
And you can get what you want.
You can download my test pbix file here
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, Anonymous
I think you should understand that Power BI removes duplicate rows from a table by default. This is due to Power BI being an aggregation tool. The only way to display duplicate lines in your table chart is to make them different in at least one field. Therefore, adding a column is unavoidable. If you think that it will lead to the user being confused when exporting the data. You can just add an index column in the Power Query editor to give them a unique ID, like this:
And you can get what you want.
You can download my test pbix file here
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Have your tried clicking on the data point its summarizing by and selecting "Dont Summarize" this may work, otherwise you will have to add a index column.
Table visualization: Display rows with duplicate v... - Microsoft Power BI CommunityHi,
Thank you for taking time to answer me. Your solution could help me a lot for the visual but when the user export the data, they could see this column calculated but they should not.
Do you have another solution ?
Magpie_Robthank you and yes I checked
