Table with flexible row dimensions

[erikm]

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!

[amitchandak · Accepted solution]

@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