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.


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

 

 

 

  • v-priyankata's avatar
    v-priyankata
    Community Support
    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.


    • v-priyankata's avatar
      v-priyankata
      Community Support
      1 year ago

      Hi

      I hope the information provided was helpful. If you still have questions, please don't hesitate to reach out to the community.
      Thanks.