Forum Discussion
Helper IIITRICKY - Data Bars Power BI Matrix Table
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.
Super UserHi 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.
BlueWhite3699Hi Ajay - cn you re send back the PBIX. thanks much appericated
- ajaybabuinturi
here is the .pbix file
https://drive.google.com/file/d/1pnxj0yzZ4CzbT_5zil-wmXE4FOfqE8-l/view?usp=sharing