Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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 displ...
Need Help
  • v-robertq-msft's avatar
    v-robertq-msft
    5 years ago

    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.

v-robertq-msft's avatar
v-robertq-msft
Community Support
5 years ago

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:

 

 

  1. I created a calculated column:
Index =

RAND()
  1. 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.