Forum Discussion

Snagalapur's avatar
Snagalapur
Icon for Helper IV rankHelper 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
  • Anonymous's avatar
    Anonymous
    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.


Snagalapur's avatar
Snagalapur
Icon for Helper IV rankHelper 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
    Icon for Helper IV rankHelper 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)
       }

     

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      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

        Hi

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