First of all, this is a continuation of a topic that was discussed not long ago. This is the original discussion in case you want additional background/context:
In addition, I have included a quick video (with audio) explaining what I had done before and what I’m needing help with right now. The video is at the bottom of this post. The explanation in the video is a little rushed, but I had to keep it short so my file wouldn’t be too big to upload. Sorry!
Also attached below is a sample PBIX file that takes what I had shared in the previous discussion and starts to add “What-If Analysis” capability for report users. The parameter allows the user to increase/decrease the number of “Type 1” events (which won’t make sense until you look at the file) by 0-100%. As the parameter value changes, the visuals adjust based on the new value for “Type 1” events at all locations.
Where I’m getting stuck is in trying to make it possible for the user to select one or more locations, and having the adjustment made by the parameter value only apply to the selected location(s). Locations can be “selected” in one of two ways:
- selecting one or more locations from the table that lists all locations, or
- using the region slicer to select all locations in that region.
I know none of this really makes sense unless you examine the PBIX file first, so if there is additional info that I can provide to help clarify what I’m trying to accomplish, please let me know, and I’ll try to provide it.
Thanks in advance!
Demo file: eDNA Demo 3.pbix (1.2 MB)