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...
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...