Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
You have to try to manage using one of the two ways, no functionality directly available.
Measure slicer
Bookmark
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
Hi @Anonymous ,
Has your problem been solved? If yes, please consider Accepting it as the solution to help the other members find it more quickly.
Best regards,
Lionel Chen
So, yes, you can do this with the Disconnected Table Trick. In general, to use a measure in that way, you need to use the Disconnected Table Trick as this article demonstrates: https://community.powerbi.com/t5/Community-Blog/Solving-Attendance-with-the-Disconnected-Table-Trick....
In short, your 2 drop downs are disconnected tables. You use SELECTEDVALUE for example to grab the value in the dropdown slicer and you use that in your measure to display the appropriate KPI, value, etc. Works like a charm. So, think of it this way.
Line value measure =
SWITCH(SELECTEDVALUE('Line KPI'[KPI]),
"Walk In",<do some calculation here>,
"Something Else",<do some other calculation here>
)
You have to try to manage using one of the two ways, no functionality directly available.
Measure slicer
Bookmark
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
This type of functionality is not natively supported (as far as I am aware). It could be mimicked I guess, using a table with KPI names and a monster of a measure that calculates completely different things based on the selected KPI name in a slicer.
Hope this helps.
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |