Forum Discussion

BlueWhite3699's avatar
BlueWhite3699
Icon for Helper III rankHelper III
1 year ago
Solved

TRICKY - Data Bars Power BI Matrix Table

Hi Experts   is the following possible as a data bars as conditinal formatting in a matrix table in Power BI   If you look at the percentage column where we have 100% full green as shown in the p...
  • ajaybabuinturi's avatar
    1 year ago

    Hi BlueWhite3699,

    Power BI does not natively support split-color progress bars (like green for completed and red for remaining) using data bars in conditional formatting inside matrix visuals.

    The built-in data bar conditional formatting in matrix tables only supports:

    • Single-color bars

    • Bar length based on value, but not multiple segments

    • No logic for dual-color thresholds (e.g., green/red splits)

    However I have workaround, you can try this measure.

    ProgressBar = 
    VAR pct = SUM('Status'[Percentage])
    RETURN
    REPT("█", ROUND(pct * 10, 0)) & REPT("░", 10 - ROUND(pct * 10, 0))

    Thanks,
    If you found this solution helpful, please consider giving it a Like👍 and marking it as Accepted Solution✔. This helps improve visibility for others who may be encountering/facing same questions/issues.