Slicer selection determine the column of the table

[Edwin1234]

Hi, I would like to ask is it possible that Power BI able to develop the dashboard like the photo attached ? If can, may I get some ideas on how to develop ? 

The dashboard has 5 slices and each slicer is referred to the column of the table, the selection of slicer is the column name which able to select the column name and the table able to display the data of that column. The 1st slicer is referred to the 1st column of the table, 2nd slicer is referred to the 2nd column and so on. The 2nd column of the table is like the drill-down of the 1st column, 3rd column is like the drill-down of the 2nd column while column 4 and column 5 are the measure value. 

For example, when the user selects 'region' for the 1st slicer, 'distributor' for the 2nd slicer, 'salesman; for the 3rd slicer, 'year/month' for the 4th slicer and 'value in box' for the 5th slicer, the table will show all the regions for 1st column, all the distributors for the 2nd column and so on. 

Thank you

[jprdynamicapps]

Yes, this can be done by unpivoting the data.

See https://www.youtube.com/watch?v=n-OWNaCUU0o for an example.

[lbendlin · Accepted solution]

You are overcomplicating things. Teach your users how to use the "Personalize visual" process.

[Edwin1234]

Thanks @lbendlin for your suggestion, I able to customize the table with the required format. Appreciate it