Conditional Formatting

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!

 

 

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"
)