Forum Discussion
Presentation variables
can we capture the values form dashboard prompt in variable and pass it to the underlying report of the Column formulas
for example I want to build something like this
case when Month is selected filter (measure using Month between start month and end month)
case when Quarter is selected filter (measure using Month between start Quarter and end Quarter)
Else select YTD
3 Replies
Hello Anonymous,
You can create a hardcoded table containing values : "Monthly","Quarterly" and "Yearly".
and a measure is to be created as :
Measure = IF ( ISFILTERED(Table[Column]) && SELECTEDVALUE(Table[Column])="Monthly",[Your Monthly measure],
ISFILTERED(Table[Column]) && SELECTEDVALUE(Table[Column])="Quarterly",[Your Quarterly measure],
[YTD Measure])
Hope this helps.
Hello,
Table[Column] is the column from the new hardcoded column, and here, we arent equating with ISFILTERED function but with the SELECTEDVALUE function.
Let me know if it still doesn't work.
