Forum Discussion
Slicer for different KPI
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 , 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-fc4095ae9afd
Power BI Field Parameters- Measure Slicer and Axis/Dimension slicer: https://youtu.be/lqF3Wa1FllE
2 Replies
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-fc4095ae9afd
Power BI Field Parameters- Measure Slicer and Axis/Dimension slicer: https://youtu.be/lqF3Wa1FllEamitchandak thank you very much. It worked as expected.
