Slicer for different KPI

[EvaldasD]

Hi all

I need help creating a slicer where i could filter different KPI's like Units sold, cost of sales, revenue etc.

I am creating table by month and want to be able to filter by KPI.

I have table like this

Product Name	Units Sold	Cost	Sale
Apple	1	1	2
Watermelon	2	5	10
Pears	3	10	20

I want to be able to use slicer for heading so it would show only selected KPI.

Example below

	Cost
Apple	1
Watermelon	5
Pears	10

Thanks

[EvaldasD]

@amitchandak thank you very much. It worked as expected.

[amitchandak · Accepted solution]

@EvaldasD , I think Field Parameters can help

Power BI Field Parameters — A Quick way for Dynamic Visuals: https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9af...
Power BI Field Parameters- Measure Slicer and Axis/Dimension slicer: https://youtu.be/lqF3Wa1FllE