Chart with Dropdown selections

[Anonymous]

Hi ,

Is it possible to create chart like below

[ramdas_01]

Tidy Up your Power BI report & Display Multiple Measures in a Chart using Drop Down Box & Switch DAX...

This will surely help you

[v-lionel-msft]

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

[Greg_Deckler]

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>

  )

[amitchandak · Accepted solution]

You have to try to manage using one of the two ways, no functionality directly available.

Measure slicer

https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...

Bookmark

https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive

[JarroVGIT]

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.