Create a slicer with column headers and then show only the selected column header data in a table

[AK2]

Is it possible to create a slicer with column headers and then show only the selected column header data in a table visual?

I would Like to create a drop-down slicer that only shows header names and not values (Campaign Name, Site Name, Media Buy Name, Impressions, Clicks, CTR). I want to create a table that only shows the data for the header names which I have selected from the slicer (For ex If I select "Campaign Name" and "Media Buy Name" from the Slicer the Table only shows all the data for "Campaign Name" and "Media Buy Name")

Campaign Name	Site Name	Media Buy Name	Impressions	Clicks	CTR
Campaign Name 1	Site Name 1	Media Buy Name 1	21	12	0.44 %
Campaign Name 1	Site Name 1	Media Buy Name 2	24	98	0.70 %
Campaign Name 1	Site Name 2	Media Buy Name 3	67	4	0.19 %
Campaign Name 2	Site Name 3	Media Buy Name 21	45	12	0.21 %
Campaign Name 2	Site Name 1	Media Buy Name 22	67	24	0.52 %
Campaign Name 2	Site Name 1	Media Buy Name 23	89	8	0.22 %
Campaign Name 2	Site Name 1	Media Buy Name 24	34	0	0.00 %
Campaign Name 3	Site Name4	Media Buy Name 31	54	8	0.03 %
Campaign Name 3	Site Name 2	Media Buy Name 32	23	10	0.03 %

Please, can anyone help?

Thanks a lot!

[Idrissshatila]

Hello @AK2 ,

Yes, you can do this using field parameters.

check this link for instructions

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

If I answered your question, please mark my post as solution, Appreciate your Kudos  👍

Follow me on Linkedin