Slicer to show different tables

[Orange_girl]

Hi all, I want to create a report with just one chart, which will show different tables depending on slicer selection. For example if you select 'shopping' in the slicer, you get a table with different products, their price, weight, description etc. But then if you select 'movie' in the slicer, you see a table which shows movie title, lead actor, genre etc. So this is slight different than dynamic column slicer, because I literally want a different table / set of data displayed depending on what slicer is selected. Is that possible in power bi? 

[Orange_girl]

Thank you! This is exactly what I was looking for! 

[speedramps · Accepted solution]

Thanks for your question ...

Firstly, lear how to use "field parameters" to dynaically select columns and measures to appear on a vsiual.

Learn how here https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters

Next learn how to "group" those field parameters into shopping and movie groups.

Learn how here https://www.youtube.com/watch?v=qlhcN3A0HNU

Then use hierarchy slicers so the user can selcet the group names, which will select and dispaly he member fields.

Thanks for the clear description of the problem. I wish everyone did that!

Remember we are unpaid volunteers, and you have got free expert help which took a lot of effort,
This solution works and does exactly what you asked.
So please quickly click the [accept as solution] and the thumbs up button to leave kudos. 

One question per ticket please. If you need to change or extend your request then please raise a new ticket.

You will get a quicker response and each volunteer solver will get the kudos they deserve. Thank you ! 

If you quote @speedramps in your next tickets then I will then receive an automatic notification, and will be delighted to help you again.

Please now click the [accept as solution] and the thumbs up button.  Thank you.