Forum Discussion

jeroenc's avatar
jeroenc
New Member
8 years ago

Power BI Table Visual not showing double rows

Hi all   I've been searchig for a while now, and I think I'm missing a simple property but I can't figure out where to find it... I'm searching for the ability to show all records (not only the di...
MattieG72MP's avatar
MattieG72MP
Advocate I
8 years ago

Hi All

 

Is there any movement on this topic?

I also want to display all rows in a table but without the ID as this takes up valuable space in the model!!

 

Thanks

Mattie

  • MattieG72MP's avatar
    MattieG72MP
    Advocate I
    8 years ago

    That is not great is it.

    I have 10s of megabytes of IDs in my model which is restricting use of some data.

     

    Let's hope there is some progress soon.

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    8 years ago

    Hi jeroenc,

     

    By my research, it seems that this is by design that won't show the duplicate rows on Power BI.

     

    You could post your idea in Power BI idea froum and add your comments there to improve Power BI and make this feature coming sooner.

     

    Best Regards,

    Cherry

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      jeroenc

      v-piga-msft  Is there any proper solution to this?  I thought by adding a unique column to table like index column we can have all rows included and as a workaround, if dont want to show that index column in table., we can format the heading and values color so we can hide it

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        I spend several days on this issue! I also trying renaming duplicate values using Python, but there was other problems when publishing that!

         

        Simple solution: "Adding a unique index column to the table and showing that in the table":

         

        https://community.powerbi.com/t5/Desktop/How-to-keep-all-rows-Even-they-are-duplicates-in-Power-BI/td-p/501578

         

        However, this again does not solve the problem fully. For example, I want to have all values separately in a filter, but it shows only one of them. So, maybe I have to rename duplicates and indicate them as  A1, A2, A3...