Forum Discussion

BILearner's avatar
BILearner
Advocate I
9 years ago
Solved

How to treat Duplicate rows as Unique Rows

Hi, I am relatively new to BI space, I looked through the posts but I coudn't find what I was looking for. I need a way to treat duplicate rows as unique values so that the visual is not grouped b...
Need Help
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    BILearner

     

    Hi, an easy wayis insert the ID Field and reduce his width to hide it.

     

    Regards

     

    Victor

    Lima- Peru

Vvelarde's avatar
Vvelarde
Community Champion
9 years ago

BILearner

 

Hi, an easy wayis insert the ID Field and reduce his width to hide it.

 

Regards

 

Victor

Lima- Peru

BILearner's avatar
BILearner
Advocate I
9 years ago

Vvelarde Thanks for this solution/workaround, is there any other way to do it without including the ID column at all? because in the original data there are more number of Columns with bigger column headings and I am using column header word wrap to adjust the width of the columns to present data in the available space. So the problem with this solution is the width of header row increases significantly covering more area of the visual if I hide(Reduce the width of column to hide it) the ID column.

And if I do not use the word wrap for column headings then column heading would not be readable.

 

Thanks,

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    9 years ago

    Hi BILearner,

     

    I am afraid adding another column is necessary. There is a message that "Duplicate rows were removed from the data" even I tried to use a R visual. That makes sense. Firstly, it's a report, which isn't just a list of records. Secondly, if there are hundreds of such rows, how we can handle them.

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Best Regards!

    Dale

     

    • BILearner's avatar
      BILearner
      Advocate I
      9 years ago

      Hi v-jiascu-msft, 

       

      Thanks for the information. Can following R plot be acheived with PBI? This is becasue PBI visual would allow further interactivity. Also I do not want to concatenate ID column with the FName column to acheive this as the string/label would be very lenghty in the original data.   

       

       Thanks!