How to show a table visual based on headers names select from slicer?

[NISHA_S]

Is there any way to show table visuals data columns based on headers names listed in slicer ? Based on slicer selection i want to display columns in tables.I have more no of columns in table...Plse help

[v-yiruan-msft · Accepted solution]

Hi @NISHA_S ,

You can refer the blog below to achieve it by using page navigation option.

DYNAMIC MULTIPLE COLUMN SELECTION IN POWER BI

Best Regards

[amitchandak]

@NISHA_S , Unpivot the data so that A,B,C become column values in rows.

https://radacad.com/pivot-and-unpivot-with-power-bi

Then you can use come column on row and that new column on the column on matrix and slicer

or explore if calculation groups can help
https://www.sqlbi.com/blog/marco/2020/07/15/creating-calculation-groups-in-power-bi-desktop/

[NISHA_S]

But am not using matrix table..I just using table visual only