Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

How to Sort By Rank on PBI Visuals

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 ...
General Comment
Need Help
v-jianboli-msft's avatar
v-jianboli-msft
Icon for Community Support rankCommunity Support
3 years ago

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's avatar
    Anonymous
    Not applicable
    3 years ago

    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 ?