The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi Team,
i have created one measure which aggregate KPI, i want to showcase that KPI as card in report on header.
Problem is when i use slicer on that report values of that KPI is getting change, i want that KPI not affected by any slicer in report any suggestions ?
Solved! Go to Solution.
Hi @shashank,
You can control the influence between each slicer and visual through "Edit Interactions".
Select a slicer, in ribbon under Visual Tools, click "Format". On the far left is "Edit Interactions". If you turn it off, the KPI visual won't be affected by the selection.
If you have any question, please feel free to ask.
Thanks,
Yuliana Gu
Hi @shashank,
You can control the influence between each slicer and visual through "Edit Interactions".
Select a slicer, in ribbon under Visual Tools, click "Format". On the far left is "Edit Interactions". If you turn it off, the KPI visual won't be affected by the selection.
If you have any question, please feel free to ask.
Thanks,
Yuliana Gu
It worked perfectly thanks a ton...:)
User | Count |
---|---|
79 | |
74 | |
42 | |
30 | |
28 |
User | Count |
---|---|
108 | |
96 | |
53 | |
48 | |
47 |