Forum Discussion
Chart with Dropdown selections
Hi ,
Is it possible to create chart like below
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
5 Replies
- Greg_DecklerCommunity Champion
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/ba-p/279563.
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>
)
- JarroVGITResident Rockstar
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.
- amitchandakSuper User
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
- v-lionel-msftCommunity Support
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 - ramdas_01Regular Visitor