Forum Discussion
BlueWhite3699
Helper III
1 year agoTRICKY - 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...
- 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.
BlueWhite3699
Helper III
1 year agoHi Champ - its the progress column we need to change not the Percentage column