Showing level of aggregation in reports

[Anonymous]

Hi

While teaching Power BI Desktop/DAX this week, I had an unusual request: the client wants to indicate levels of aggregation in some reports 

E.g. would it be possible to asterisk fields set to "Don't summarise" :

I understand the company receives some data pre-aggregated from external sources and other data in raw transactional form. Quite why they need to distinguish the two types of data on a report beyond me,  but is there a way it can be done?

Thanks!

[v-lili6-msft · Accepted solution]

hi, @Anonymous 

For your requirement, you could try this way:

In Modeling->Properties->Default Summarization, Set it Don't summarize

And then if you want to summarize the data, you could set the summarization as your screenshot,

It will show the level aggregation in the visual.

Regards,

Lin