Forum Discussion
Changing Y-value dataset from dropdown selection for a graph figure
Hello!
I have the following sample dataset:
| Product | Amount Water | Amount Sugar | Amount Zinc | Date Added |
| Pink Drink | 0.002 | 0.03 | 0.001 | 7/31/2019 |
| Blue Drink | 0.004 | 0.1 | 0.003 | 7/24/2019 |
| Black Drink | 0.001 | 0.33 | 0.01 | 6/25/2019 |
| Blue Drink | 0.02 | 0.55 | 0.04 | 4/3/2019 |
| Pink Drink | 0.01 | 0.22 | 0.007 | 1/2/2019 |
| Blue Drink | 0.022 | 0.66 | 0.009 | 12/1/2019 |
| Black Drink | 0.0011 | 0.87 | 0.012 | 3/4/2019 |
On my dashboard, I have 2 initial selection criterias:
1. a dropdown selection of what product the user wants to focus on (Blue, Black, or Pink Drink)
2. a date range (data is selected from Date Added column)
I want to select the Y-value dataset from the middle 3 headers (Amount Water, Amount Sugar, Amount Zinc)
The X-values will be the date range selected above.
Does anyone know how to create a dynamically changing figure where you cans select your Y-axis dataset columns from a dropdown selection?
Thanks in advance!
2 Replies
You can do that in a measure, you may need a disconnected table. 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
Hi niketowns ,
Maybe you can refer to this answer:
Dynamically change Y axis based on input from drop down or list select
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
