Matrix - Selectable Dimensions

[mkudis]

I'm coming from a Qlik background where I can build custom groups that an end user can cycle through as their dimensions in a table or pivot table.  Essentially, it would be a matrix in Power BI, but the user can choose the dimension at each level of the pivot, as long as I built it into the custom group.  So if I had Branch, Customer, City, State, Item, Product Group, Supplier in the custom group, the end user would be able to, at each level of the pivot, select one of those dimensions to view the data by.

Is there anything equivalent in Power BI, or anything that I can do to mimic that?  I'm trying to do a proof of concept to see if moving to Power BI would work for us, and this is one of the major stumbling blocks for me right now.  Everything else seems to be easily translatable in my document, and everything else is working really well.  But this is very useful functionality that our users are used to having, and not something that I'd want to omit.  Thank you.

[Smalfly · Accepted solution]

Hi @mkudis ,

you might have a look at using field parameters:

https://www.sqlbi.com/articles/fields-parameters-in-power-bi

Since this feature is still in preview, make sure to enable it in Power BI Desktop in Options / Global / Preview Features / Field parameters.