How to Sort By Rank on PBI Visuals

[Anonymous]

I am able to achieve sort on Table/Grid visual

When i switch to Bar/Line chart and place rank in "Tooltip" section - it converts the "Rank" column as "Count of Rank" or not allowing me to remove "Do not summarize" for this scenario - why ? 

Any reason to fix this ? Please advise.

Example for Table : 

Example : for Visuals 

[v-jianboli-msft]

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.

[v-jianboli-msft]

Hi @Anonymous ,

According to my knowledge, Table visual and Bar/Line chart are not the same. Since you have to choose the right aggregation for your values when you use Bar/Line chart, in other words your data can't be displayed in this way by don't summarize, so when you add the Rank field to tooltips, you have to choose the right aggregation for it too, you can consider aggregation like sum\max or recreate a measure for it.

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.

[Anonymous]

So, is it safe to say - it's a limitation in Power BI to allow "Do not summarize" on columns in grid vs not possible with visuals ? 

[Anonymous]

Apologies - by mistake clicked "Accept as solution" 

I have tried with both String & Number - same issues exist for both data type

[selimovd]

Hey @Anonymous ,

which format does the column have?

This usually happens when the values are saved as string and not as number.

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic