Not summarizing option for specific visual objects

[Anonymous]

Goodmorning,

I have troubles not summarizing specific variables for specific visual objects. With "table" visual object there seem not to be any problems, whereas for lines & histograms charts I cannot make it work.

Thank you.  

[Anonymous · Accepted solution]

The idea is that I want to visually represent target values for historical data, with target values coming from a different source (as they are designed to be dynamic). Whenever I'm switching the time horizon of historical data, the target has to be constant in values.

But while for some specific visual objects PBI gives me the possibility of not summarizing, for some other it doesn't. I.e. histograms or linecharts.

In the end I managed to do it with LOOKUPVALUE function.

[Icey]

Hi @Anonymous ,

Lines & histograms chart visuals are used for displaying summary data.

Just take the line chart visual as an example, you can image the line chart Axis property is the column group of the matrix, Legend property is the Row group of the matrix. If there were more than one record for the same intersection of the column and row groups, we need to aggregate the values. So there are many aggregate functions for summarizing the data instead of "Do not Summarize".

The "Default Summarization: Do Not Summarize" option apply to the field itself. Once we place the filed into visuals, it will depend on the visual design to use this. In chart visual, "Do Not Summarize" is not available but in a table visual, it can support.

In your scenario, as your sample data contain one record for each Axis values, use the SUM() function will also display the raw data. But if there are duplicate record for each Axis, SUM will aggregate the values.

Reference: Solved: Re: Option to choose "Don't Summarize" Missing. "... - Page 2 - Microsoft Power BI Community

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.