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

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!