Forum Discussion

AMBP1973's avatar
AMBP1973
Helper III
2 years ago
Solved

Conditional Formatting

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 🙂

Need Help
  • Uzi2019's avatar
    Uzi2019
    2 years ago

    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!

     

     




  • Jihwan_Kim's avatar
    Jihwan_Kim
    2 years ago

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

     

     

3 Replies

  • Uzi2019's avatar
    Uzi2019
    Community Champion
    2 years ago

    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!

     

     




  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    2 years ago

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

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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