Is there a way to dynamically change an OD matrix in Power BI?

[JUtah_92]

I have a large data table of journeys which include the Origin Code, Destination Code and number of journeys. Locations are also classfied into Categories like "A", "B" and "C", so that a journey might be classfied as AC if going from an "A" category location to a "C" category location. This allows me to calculate how many journeys are made between different categories.

I would like to be able for users to choose locations from a list and "change" thier cateogry to see how this would affect journies made between categories. So far I've only been able to accomplish this by changing the source file classifications and refreshing the data, but this isn't an appropiate solution for users of the report.

[v-stephen-msft]

Hi @JUtah_92 ,

You can try slicers. Have you tried it before?

Slicers in Power BI

Best Regards,

Stephen Tao

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

[lbendlin]

Enable the "personalize visual"  feature and teach your users how to use it.  They can dynamically swap dimensions around.