The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
but my data I get when console logs has the duplicate elements in value removed when I select Brand and sales.
[
["SamSung",10],
["SamSung",11],
["SamSung",12],
["SamSung",13],
["SamSung",15],
["SamSung",16],
["SamSung",17]
]
How can i fix this.
Solved! Go to Solution.
Hi @LortT
@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
Proud to be a Super User!
My course: Introduction to Developing Power BI Visuals
On how to ask a technical question, if you really want an answer (courtesy of SQLBI)
Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?
Hello, I want to create a table in cusom visuals and display my information. I choose dataViewMappings as table and dataRoles with kind as row and value. My data has 9 rows and there is overlap, data sales duplicated in 10$ and 11$, When I drag brand into rows and Sales into value, the data returned to me is 7 rows instead of 9. The 2 duplicate values 10$ and 11$ have disappeared. I want to ask if there is any way I can get all data without removing duplicates
To prevent automatic aggregation you need to add a unique field to your visual, like a row index.
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?
Hi @LortT
@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
Proud to be a Super User!
My course: Introduction to Developing Power BI Visuals
On how to ask a technical question, if you really want an answer (courtesy of SQLBI)
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
4 | |
4 | |
3 | |
2 | |
2 |