Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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!
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
91 | |
85 | |
65 | |
62 | |
58 |
User | Count |
---|---|
150 | |
113 | |
95 | |
80 | |
72 |