Forum Discussion
Helper IWhat-if Parameter With Variable End Value
Helper II see now what my problem was. I have a date filter for the complete dashboard, so it is making the sum of all the dates instead for the one applied. Do you think there is a workaround for that?
Thank you so much for the response! It was very insightfull!
Super UserSince the parameter is a calculated table, it cannot be responsive to your date filters.
There may be another way to ultimately achieve your actual end goal that you're creating this parameter for, but I don't have enough context to make any specific suggestions.
- Pablinho
I thought I could find a workaround but nothing so far. What I have is a lot of appended queries. Each table has a date column so I have a big appended table with almost the same values repeating but with a set of diferent dates. For example:
ID1 DATE1 ETC
ID2 DATE1 ETC
ID3 DATE1 ETC
ID4 DATE1 ETC
ID1 DATE2 ETC
ID2 DATE2 ETC
ID3 DATE2 ETC
ID4 DATE2 ETC
I have a slicer to filter by date so that only the information for that day is presented. I also have a gauge that shows a percentage and it changes based on the values that each date has. With a What-if parameter I am able to add a slicer that modifies that gauge with a pre-set value. However I have that daily value. What I want to do is to automatically plug that value to the parameter, so that it changes based on the date.
Right now the parameter returns the sum of all the dates because the filter is not being applied.
I hope that gives more context. Thanks!
- AlexisOlson
I'm not sure I fully understand the purpose of the parameter. Generally, a parameter is used to give control of some variable to the end user.
You can use measures to define min/max/target on a gauge visual and measures are responsive to filters. Is this sufficient or does the user need to control something manually (rather than relying on a calculation to do the work)?
- Pablinho
The user needs to control something manually so that they can do a What-If? Analysis. By default the gauge is at a current value for the day (20%). Then the idea is that the user can use a slicer or anything to do a proyection, let's say increase 5%. However that slicer max value is defined each day. Right now I need to manually see what the value is an plug it into the parameter, but want to do it automatically.