Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi!
I have searched for awhile and I can't seem to find a solution.... I have a dashboard matrix which is broken out by Month in the columns. Underneath each month is a ranking (from 1st - 200th depending on the month), a name, # in sales, and $ in sales. Each month there is a set of "favorite names" and they change depending on the month. I need to be able to highlight those names within the month and I was thinking if I made some sort of DAX to distinguish these favorite names, I can do a conditional rule where that name is highlighted yellow.
Basically the DAX that I am trying to build would go something like this:
IF [month] = "January" OR "February"" AND [favorite name] = "John" or "Sam" or "Joe" (etc), then "F" else blank
IF [month] = "March" OR "APRIL" OR "MAY" AND [favorite name] = "Sue" OR "Anne" OR "Rose" then "F" else blank
ETC for each month.
Thank you!
As @SachinNandanwar points out, using both SWITCH ( TRUE(), ... ) and IN syntax will help with this:
SWITCH (
TRUE (),
[month] IN { "January", "February" }
&& [favorite name] IN { "John", "Sam", "Joe" }, "F",
[month] IN { "March", "April" }
&& [favorite name] IN { "Sue", "Anne", "Rose" }, "F",
[ ... ],
BLANK ()
)
You could use a SWITCH statement
SWITCH(
TRUE(),
(month = "January" || month = "February") && [favorite name] IN {John,Sam,Joe},
.
.
BLANK()
)
You can refine the above syntax.
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
25 | |
18 | |
18 | |
17 | |
16 |
User | Count |
---|---|
28 | |
27 | |
19 | |
15 | |
14 |