Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi everyone,
I’ve been using SWITCH for my report but my issue is that its default value was not showing at all and I always have to keep at least one filter on.
Variance View = SWITCH(TRUE(),
VALUES(‘Table1’[Var]) = “Enabled”, [YOY VAR],
VALUES(‘Table1’[Var]) = “Disabled”, [TOTAL],
[TOTAL]))
Attached is the matrix when the variance view is disabled. When I clear the filter, I expect it to still show [TOTAL], but the data disappears and there’s only a message saying ‘Can’t display the visual.’ Could anyone point out what did I do wrong?
Solved! Go to Solution.
Hi @TP129
You are using VALUES, so when you do not select the slicer to filter Var, it returns error, you can do it like this
Variance View =
VAR CurVar = SELECTEDVALUE('Table1'[Var],“Disabled”)
RETURN
SWITCH(TRUE(),
CurVar=“Enabled”, [YOY VAR],[TOTAL])
Hi @TP129
You are using VALUES, so when you do not select the slicer to filter Var, it returns error, you can do it like this
Variance View =
VAR CurVar = SELECTEDVALUE('Table1'[Var],“Disabled”)
RETURN
SWITCH(TRUE(),
CurVar=“Enabled”, [YOY VAR],[TOTAL])
Oh I see what's the problem here. It works now, thank you very much!