Forum Discussion

fbittencourt's avatar
fbittencourt
Icon for Helper IV rankHelper IV
1 year ago
Solved

Combine conditional formating ( icone + color)

Hi guys !! I need to combine the value color change with the icon besides on a card.
 
 I have tried this, but is not working.
      // ABS(KP) >= 0 && ABS(KP) <= 0.0549, "#24B64A" & "🟢",

       // ABS(KP) >= 0.055 && ABS(KP) <= 0.1049,"#EAC905" & "🟡",

     //   ABS(KP) >= 0.105 && ABS(KP) <= 1, "#E33010" &"🔴",
 
 
 
 This code below works well.( add the colors values)
 
PCTKPI Icon + Value =

VAR KP = [PctKPI 2]

VAR Icon =

    SWITCH(

        TRUE(),

        ABS(KP) >= 0 && ABS(KP) <= 0.0549, "🟢",

        ABS(KP) >= 0.055 && ABS(KP) <= 0.1049, "🟡",

        ABS(KP) >= 0.105 && ABS(KP) <= 1, "🔴" ,

        ""

    )

RETURN

Icon & " " & FORMAT(KP, "0.00%")
 
Tks all!!
Need Help
  • v-ssriganesh's avatar
    v-ssriganesh
    1 year ago

    Hi fbittencourt,
    Thank you for reaching out to the Microsoft Fabric Forum Community.

    I’ve reproduced your scenario in Power BI Desktop using your icon + color formatting logic, and I was able to achieve the expected output combining both the KPI value and the icon with conditional color formatting in a single card.

    For your reference:

    • I used the new card visual.
    • The KPI icon and value were combined using a DAX measure.
    • Conditional formatting was applied using a separate measure through the fx (Field value) option in the visual's Color formatting pane.

    I’ve attached a .pbix file to help you review.

    If this information is helpful, please “Accept it as a solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
    Thank you.

2 Replies

  • bhanu_gautam's avatar
    bhanu_gautam
    Icon for Super User rankSuper User
    1 year ago

    fbittencourt 

    Create a measure for the icon:

    DAX
    PCTKPI Icon =
    VAR KP = [PctKPI 2]
    VAR Icon =
    SWITCH(
    TRUE(),
    ABS(KP) >= 0 && ABS(KP) <= 0.0549, "🟢",
    ABS(KP) >= 0.055 && ABS(KP) <= 0.1049, "🟡",
    ABS(KP) >= 0.105 && ABS(KP) <= 1, "🔴",
    ""
    )
    RETURN
    Icon

     

    Create a measure for the value:

    DAX
    PCTKPI Value =
    VAR KP = [PctKPI 2]
    RETURN
    FORMAT(KP, "0.00%")

     

    Combine the icon and value in a new measure:

    DAX
    PCTKPI Icon + Value =
    [PCTKPI Icon] & " " & [PCTKPI Value]

     

    Go to the card visual where you want to display the combined measure.
    Select the measure PCTKPI Icon + Value.
    In the visualizations pane, go to the "Format" section.
    Find the "Data label" or "Values" section (depending on the visual type).
    Click on "Conditional formatting" and choose "Font color".
    Set up rules based on the value of [PctKPI 2] to apply the desired colors.

  • v-ssriganesh's avatar
    v-ssriganesh
    Icon for Community Support rankCommunity Support
    1 year ago

    Hi fbittencourt,
    Thank you for reaching out to the Microsoft Fabric Forum Community.

    I’ve reproduced your scenario in Power BI Desktop using your icon + color formatting logic, and I was able to achieve the expected output combining both the KPI value and the icon with conditional color formatting in a single card.

    For your reference:

    • I used the new card visual.
    • The KPI icon and value were combined using a DAX measure.
    • Conditional formatting was applied using a separate measure through the fx (Field value) option in the visual's Color formatting pane.

    I’ve attached a .pbix file to help you review.

    If this information is helpful, please “Accept it as a solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
    Thank you.