Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |