Forum Discussion
Sort on multiple visuals (Matrix) at the same time possible?
I am sharing my Pbix file here.
I am trying to see if it is possible sort two visuals at the same time.
For instance, if user clicks the sort button on the "Facility Name" on the Today matrix, I would like the sorting of "Facility Name" for the Variance matrix to follow.
Is it possible?
If it is not possible, how do I create a separate column that I could insert into Today matrix (as an extra column)?
This is the detail of the measure I user for Variance table:
MeasureDayBefore = COUNT('vw_daily_today'[ClientID]) -
COUNT('vw_daily_priorday'[ClientID])
If these two options are not possible, is there any way to disable sorting (maybe that way, I don't have to worry user clicks sort on visual by accident) on Matrix visuals?
Thanks.
As far as I know, thre is no way.
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/
3 Replies
- VahidDMSuper User
Hi JustinDoh1
Check this link to find a trick to disable the Sorting:
https://community.powerbi.com/t5/Desktop/How-to-disable-sorting-in-Table-visual/td-p/1240794
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/ - JustinDoh1Post Prodigy
VahidDM Thank you for your feedback. Is there anyway to "sort" two visuals together? Thank you.
- VahidDMSuper User
As far as I know, thre is no way.
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/