cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Edwin1234
Frequent Visitor

Slicer selection determine the column of the table

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

 

image.jpeg

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

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

View solution in original post

3 REPLIES 3
jprdynamicapps
Helper III
Helper III

Yes, this can be done by unpivoting the data.

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

lbendlin
Super User
Super User

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

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

Helpful resources

Announcements
August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 24 without aka link and time 768x460.jpg

Ted's Dev Camp - July 28, 2022

Watch Session 24 of Ted's Dev Camp along with past sessions!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors