Conditional Formatting

[AMBP1973]

Hello,

I am developing a report on a SWOT analysis. I have a slicer at the top of each page with Horizontal Selections. I would like to sort them in the order of 'SWOT', and colour each button accordingly. Could someone please assist on how this could be acheived.

I also have a table that has the SWOT results, I would like to also have each cell coloured according to the SWOT. I would really appreciate assistance on this also.

Thanks in advance 🙂

[Uzi2019 · Accepted solution]

Hi @AMBP1973 

You have to create seperate calculated column. please followthe steps:
Step1: create calculted column

Sort =

SWITCH(TRUE(),

S[SWOT]="Strength","1.Strength",

S[SWOT]="Weakness", "2.Weakness",

S[SWOT]="Opportunity", "3.Opportunity",

S[SWOT]="Threat", "4.Threat"

)

Step2: take you sort column in your table 

Step3: for color each cell of a swot , you have to write measure for that.
create measure as below

Color = IF(MIN(S[SWOT])="Strength","Red",IF(MIN(S[SWOT])="Weakness","Green",IF(MIN(S[SWOT])="Opportunity","Yellow","Blue")))

Step4: you can take your own color / hex code . apply the condition formatting on background of a swot column.

 
Then select field value and measure

Step5: final result 

I hope I answered your question!

[Anonymous]

Hi @AMBP1973 ,

Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.

If these also don't help, please share more detailed information and description to help us clarify your scenario to test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

I am not sure how your semantic model looks like, but I tried to create a sample pbix file like below.

color condition measure: = 
SWITCH ( TRUE(),
    SELECTEDVALUE('SWOT Dimension'[SWOT Type] ) ="Strength", "Green",
    SELECTEDVALUE('SWOT Dimension'[SWOT Type] ) ="Weakness", "Orange",
    SELECTEDVALUE('SWOT Dimension'[SWOT Type] ) ="Opportunity", "Light Blue",
    SELECTEDVALUE('SWOT Dimension'[SWOT Type] ) ="Threat", "Red"
)

[Uzi2019 · Accepted solution]

Hi @AMBP1973 

You have to create seperate calculated column. please followthe steps:
Step1: create calculted column

Sort =

SWITCH(TRUE(),

S[SWOT]="Strength","1.Strength",

S[SWOT]="Weakness", "2.Weakness",

S[SWOT]="Opportunity", "3.Opportunity",

S[SWOT]="Threat", "4.Threat"

)

Step2: take you sort column in your table 

Step3: for color each cell of a swot , you have to write measure for that.
create measure as below

Color = IF(MIN(S[SWOT])="Strength","Red",IF(MIN(S[SWOT])="Weakness","Green",IF(MIN(S[SWOT])="Opportunity","Yellow","Blue")))

Step4: you can take your own color / hex code . apply the condition formatting on background of a swot column.

 
Then select field value and measure

Step5: final result 

I hope I answered your question!