How to display the report dynamically based on the slicer selection?

[vinothkumar1990]

Hi,

  I have below two different datasets and both has different number of columns. 

I want to keep a fliter for student and Teacher. If i select the Student then i should be able to see the Student table report like beelow,

If i select the Teacher then i should be able to see the Teacher table reportlike beelow,

Can you please help?

Thanks,

Vinoth

[amitchandak · Accepted solution]

@vinothkumar1990 , You need to use bookmarks or you need unpivot teacher and student for that

Dynamically change chart axis in Power BI
bookmark -https://blog.crossjoin.co.uk/2018/04/20/dynamically-changing-a-chart-axis-in-power-bi-using-bookmarks-and-buttons/
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
https://www.youtube.com/watch?v=6jeSIRpjv0M
https://datamonkeysite.com/2020/10/22/change-dimension-dynamically-using-parameter-in-powerbi/

[vinothkumar1990]

@amitchandak - Thanks for the solution!

 Is that possible to use the slicer instead of buttons?