Forum Discussion
Table with flexible row dimensions
Hi,
I have a simple table with Rows and Values, with up to three drill-down levels on the rows (i.e. Country -> Region -> City or Product Category -> Product). There are many different dimensions that the user is able to slice the table from, therefore I was wondering if there is a way to create one table where the user has the option of selecting the dimensions and drill-down levels for this table.
For example, the user would be able to view the table by Country and Region, but also by Product Category and Product. Right now I have copied the same table on a different page, but that leads to many pages with all different drill-down options...
Goal is simplicity, ideally that the user is able to select the dimensions from a dropdown box.
Thanks!
erikm , As of no, change of dimension/axis can be done with Bookamrks. Unless in direct query, where you have M parameter option.
I doubt you can change the hierarchy order, if you allow use personalization option, then they can change, visual as per need
https://docs.microsoft.com/en-us/power-bi/consumer/end-user-personalize-visuals
1 Reply
- amitchandakSuper User
erikm , As of no, change of dimension/axis can be done with Bookamrks. Unless in direct query, where you have M parameter option.
I doubt you can change the hierarchy order, if you allow use personalization option, then they can change, visual as per need
https://docs.microsoft.com/en-us/power-bi/consumer/end-user-personalize-visuals