How to Sort By Rank on PBI Visuals

Hi Anonymous ,

The Bar/Line chart visual is used for displaying summarize data. You can image the Bar/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 summarize 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, if your sample data contain one record for each Axis values, use the SUM()/MAX()/MIN() function will also display the raw data. But if there are duplicate record for each Axis, SUM will aggregate the values.

Best Regards,

Jianbo Li

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