topic Re: Conditional Formatting - Switch Case in Desktop

Conditional Formatting - Switch Case

MChakri — Fri, 16 Jun 2023 18:22:06 GMT

Hello Pals,

I have a peculiar case with Switch statement as I am unable to apply conditional formatting for a single line item. Lets say, I have 5 line items and calculated against months like JAN, FEB, ...DEC, Q1, Q2, Q3, Q4, YTD etc..,I have a Grand total as 5th line item and that line item need to have a conditional formatting for "-" values. (Identified with a different color instead of default).

We would like to see the conditional formatting for Total other Margin and Net Margin should be with different color in Power BI.

Switch statement looks like the above

Re: Conditional Formatting - Switch Case

Akshaan — Fri, 16 Jun 2023 22:39:16 GMT

Hi MChakri, you can achieve this by using a similar dax measure only for a selected dimension ( in your case line 5 item).

if it doesn't works for you, please share your .pbix file.

Re: Conditional Formatting - Switch Case

MChakri — Mon, 19 Jun 2023 02:58:35 GMT

Hi Akshaan, Is this possible for only negative values...This should work if we have any negative values in the "Net Margin" column alone. Apologies for my late response.. Wanted to share the .pbix file but I don't see an option to do so.

Re: Conditional Formatting - Switch Case

Akshaan — Mon, 19 Jun 2023 04:11:38 GMT

Hi MChakri you can make this small change to get the desired result.

Please accept this as solution if it works for you to help others.

Thanks,

Re: Conditional Formatting - Switch Case

MChakri — Mon, 19 Jun 2023 05:16:51 GMT

Akshaan , see this is not working for me. One thing is that this is a derived field !! Pls correct me!

Re: Conditional Formatting - Switch Case

Akshaan — Mon, 19 Jun 2023 05:58:07 GMT

Hi MChakri , it seems you are not passing the condition for CategoryIntern column in the above measure (line 5 item). Also, can you please explain why are you using 2 different measures in here?
1. NETMARGIN- YTD

2. OTHER COGS Test

You can share you .pbix frm here.

Re: Conditional Formatting - Switch Case

MChakri — Tue, 20 Jun 2023 17:36:32 GMT

Akshaan Unable to send .pbix file as it is only allows .jpeg files only. I tried again but seems no luck. do you have any other mediums to connect?

Thanks,

MChakri

Re: Conditional Formatting - Switch Case

MChakri — Tue, 20 Jun 2023 17:58:10 GMT

https://drive.google.com/file/d/1qnaQdb_t7zq6rqZLF_T0ogQGv7VuE7Km/view?usp=sharing Here you go. Attached with .pbix file. Let me know if this is doeable. Thanks a ton!!

Re: Conditional Formatting - Switch Case

MChakri — Mon, 26 Jun 2023 06:30:59 GMT

Akshaan Any luck on the file sent to you? We can close the discussion if you are ok to help me on last step!! Thanks,

Re: Conditional Formatting - Switch Case

MChakri — Wed, 28 Jun 2023 07:18:37 GMT

Akshaan Any help is appreciated!! TIA.

Re: Conditional Formatting - Switch Case

Akshaan — Wed, 28 Jun 2023 08:20:48 GMT

Hi MChakri, This is the answer to the above asked question:

CF =

SWITCH(

SELECTEDVALUE('New Table'[Report Column]),

"Other: Audit Accruals/Credits Margin" , IF([JANNEWF]<0, "Red")

)

Here are my observations/suggestions:
1. Use hierarchies instead of calculated column Categorn intern with some additional spaces

2. You derived field i.e. JANNEWF , FEBNEWF should be in Whole Number format instead of text to make this code work.