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 III
Super User III

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 III
Super User III

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

View solution in original post

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

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors
Top Kudoed Authors