Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Fix duplicate data

Hello everyone. I have a bit of a duplicate data issue per below. I create a custom visuals and uing data like this: and this is my capabilities "dataRoles": [ { "name": "rows", "displ...
  • dm-p's avatar
    dm-p
    2 years ago

    Hi Anonymous

     

    lbendlin's answer is correct. You must include a data role in your capabilities that encourages users to add a unique identifier row to the visual dataset to make Power BI project rather than aggregate. Power BI will always aggregate to the highest possible level based on unique values in the dataset (for columns). The Violin Plot custom visual needs this, and I wrote a blog post explaining the concept with some visual aids, which should help clarify the approach you will need to take.

     

    Regards,

     

    Daniel

Anonymous's avatar
Anonymous
Not applicable
2 years ago

What you mean is adding a unique field to data or my visuals, is there any way to set the data return to not automatically delete duplicate values? I want when I drag brand into rows and Sales into value, the data will be displayed in full 9 rows like in excels data, is there any way?

dm-p's avatar
dm-p
Super User
2 years ago

Hi Anonymous

 

lbendlin's answer is correct. You must include a data role in your capabilities that encourages users to add a unique identifier row to the visual dataset to make Power BI project rather than aggregate. Power BI will always aggregate to the highest possible level based on unique values in the dataset (for columns). The Violin Plot custom visual needs this, and I wrote a blog post explaining the concept with some visual aids, which should help clarify the approach you will need to take.

 

Regards,

 

Daniel

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    thank you dm-p  and lbendlin , it work for me