Skip to main content

Power BI

New

Cross sorting between visuals

Vote (16) Share
GK7's profile image

GK7 on 15 May 2017 19:10:49

In addition to cross filtering and cross highlighting among different visuals in power BI, there should be a way all the visuals on a page get sorted if one visual is sorted on the basis of some common field or column.

Comments (4)
GK7's profile image Profile Picture

b4b56b47 6b76-4d8c-96ee-3dbef7c1b8f6 on 05 Jul 2020 23:46:59

RE: Cross sorting between visuals

Agreed, this would make the options for creating dashboards way more extensive.

GK7's profile image Profile Picture

5dd28dea 9092-40db-ae5a-ab10d8bf8f58 on 05 Jul 2020 23:42:13

RE: Cross sorting between visuals

Yes! This would be a huge help! It would enable dashboard creators to utilize small, multiple bar charts for more effective visualizations!!

GK7's profile image Profile Picture

cc4e4920 44c6-46d9-bc0c-4e18101f2f68 on 05 Jul 2020 22:51:58

RE: Cross sorting between visuals

Highly support this idea, it should be part of the 'visuals interaction'-functionality, ic telling which visual should be sorted in the same way as another visual (of course, only applicable if the dimensions used are similar). Currently there is no way to align sorting between 2 bar charts with 2 measures. For example first you want to sort on revenue descending. The second bar chart shows variance % to budget, but it can not follow the same sorting.
This is only partially adressed by the preview matrix visual, because that one can not be scaled properly.

GK7's profile image Profile Picture

a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 22:51:57

RE: Cross sorting between visuals

Must have idea! This would allow to realise this kind of best practice visualisations and comparisons:
http://www.perceptualedge.com/images/example20solution_large.jpg

Explanation of the graph
http://www.perceptualedge.com/example20.php

Credits to Stephen Few - Perceptual Edge for the graphs and the explanation.