cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
optimusprime Regular Visitor
Regular Visitor

Is there a way to set 'Don't Summarize' as default

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

1 ACCEPTED SOLUTION

Accepted Solutions
dm-p Established Member
Established Member

Re: Is there a way to set 'Don't Summarize' as default

Hi @optimusprime 

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 Smiley Happy

Daniel

1 REPLY 1
dm-p Established Member
Established Member

Re: Is there a way to set 'Don't Summarize' as default

Hi @optimusprime 

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 Smiley Happy

Daniel

Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Top Kudoed Authors
Users Online
Currently online: 47 members 910 guests
Please welcome our newest community members: