Conditional Formatting - Switch Case

[MChakri]

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 

[Akshaan]

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,

[Akshaan]

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.

[MChakri]

Pls correct me If I am wrong in above!!@Akshaan , see this is not working for me. One thing is that this is a derived field !! Pls correct me!

[Akshaan]

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.

[MChakri]

@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

[MChakri]

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!!

[MChakri]

@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,

[Akshaan]

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.

[MChakri]

@Akshaan Any help is appreciated!! TIA. 

[MChakri]

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.