Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am building my customized Visual. However, when load the table we don't want the data to be summarized. Is there a way to set the default to be 'Don't Summarize'?
Thanks
Solved! Go to Solution.
Hi @Anonymous
The dataRoles allow essentially three kinds of behaviours for fields (Grouping, Measure and a combination of the two). All will basically aggregate to the lowest specified level of grain without some kind of lower-grain field to prevent aggregation. This is the same as Power BI internally and creates challenges if you need the most atomic level of data by default.
One way around this is to introduce a 'grain' field to ensure that your dataViewMapping does not aggregate to a higher level than you want your visual to manage. A couple of custom visuals that use this pattern are Box and Whisker Chart and Violin Plot (both of which need all available data to generate distribution statistics). This is also something that Charticulator does in its custom visual export to ensure that all data rows are fed into the visual.
Hopefully this gives you some ideas 🙂
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)
Hi @Anonymous
The dataRoles allow essentially three kinds of behaviours for fields (Grouping, Measure and a combination of the two). All will basically aggregate to the lowest specified level of grain without some kind of lower-grain field to prevent aggregation. This is the same as Power BI internally and creates challenges if you need the most atomic level of data by default.
One way around this is to introduce a 'grain' field to ensure that your dataViewMapping does not aggregate to a higher level than you want your visual to manage. A couple of custom visuals that use this pattern are Box and Whisker Chart and Violin Plot (both of which need all available data to generate distribution statistics). This is also something that Charticulator does in its custom visual export to ensure that all data rows are fed into the visual.
Hopefully this gives you some ideas 🙂
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)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
13 | |
2 | |
2 | |
1 | |
1 |