Forum Discussion

Snagalapur's avatar
Snagalapur
Helper IV
1 year ago
Solved

Conditional colour format Bar chart

Hi All,   Please suggest measure to combine multiple statements of conditional colour format into one, currently my bar chart toggle between 3 options using slicer.   How to use single condition ...
Need Help
  • v-priyankata's avatar
    v-priyankata
    1 year ago



    Hi Snagalapur 

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

    Can you try below DAX


    Bar Chart Color Format = 
    VAR SelectedKPI = SELECTEDVALUE('KPI''s'[KPI's]) -- This refers to the field parameter slicer
    VAR KPIValue =
    SWITCH(
    SelectedKPI,
    "Act v. Bud", [Act v. Bud (Top 10 Bar chart)],
    "Act v. Fcst", [Act v. Fcst (Top 10 Bar chart)],
    "Act v. LY", [Act v. LY (Top 10 Bar chart)],
    BLANK()
    )
    RETURN
    IF(KPIValue < 1, "#FF0000", "#00CC66")



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


bhanu_gautam's avatar
bhanu_gautam
Super User
1 year ago

Snagalapur , You can create a measure using SWITCH

DAX
ColorMeasure =
SWITCH(
TRUE(),
SELECTEDVALUE(Slicer[Selection]) = "Act v. LY" && TABLE[Act v. LY (Top 10 Bar chart)] < 1, "#FF0000",
SELECTEDVALUE(Slicer[Selection]) = "Act v. LY" && TABLE[Act v. LY (Top 10 Bar chart)] >= 1, "#00CC66",
SELECTEDVALUE(Slicer[Selection]) = "Act v. Bud" && TABLE[Act v. Bud (Top 10 Bar chart)] < 1, "#FF0000",
SELECTEDVALUE(Slicer[Selection]) = "Act v. Bud" && TABLE[Act v. Bud (Top 10 Bar chart)] >= 1, "#00CC66",
SELECTEDVALUE(Slicer[Selection]) = "Act v. Fcst" && TABLE[Act v. Fcst (Top 10 Bar chart)] < 1, "#FF0000",
SELECTEDVALUE(Slicer[Selection]) = "Act v. Fcst" && TABLE[Act v. Fcst (Top 10 Bar chart)] >= 1, "#00CC66",
"#000000" // Default color if none of the conditions are met
)

  • Snagalapur's avatar
    Snagalapur
    Helper IV
    1 year ago

    Thank you for details. currently i'm facing below error , could you please suggest, currently i'm using calculated measures in slicer as parameters.

     

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Please share some sample data and show which fields are placed in the bar chart and in the field parameter?

      • Snagalapur's avatar
        Snagalapur
        Helper IV
        1 year ago

        Hi Please find details of fields used in chart.

        Measures:
        Act v. Bud (Top 10 Bar chart) =  SUM('Table'[actual])- SUM('Table'[budget])
        Act v. LY (Top 10 Bar chart) =  SUM('Table'[actual])- SUM('Table'[LY])
        Act v. Fcst (Top 10 Bar chart) =  SUM('Table'[actual])- SUM('Table'[Fcst])

        Field paramater: 

        KPI's = {
             ("Act v. Bud", NAMEOF('MEASURES_TABLE'[Act v. Bud (Top 10 Bar chart)]), 0),
            ("Act v. Fcst", NAMEOF('MEASURES_TABLE'[Act v. Fcst (Top 10 Bar chart)]), 1),
            ("Act v. LY", NAMEOF('MEASURES_TABLE'[Act v. LY (Top 10 Bar chart)]), 2)
           }