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 UserYou can't do it with database.
But you can do it with background colurs
RAG =
var mypercent = MAX('Status'[Percentage])
RETURN
SWITCH( TRUE(),
mypercent = 1, "Green",
mypercent >= 0.82, "Yellow",
"Red"
)
Please click thumbs up because I tried to help.
Then click [accept solution] if it fixed your problem.
Thank you !