This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreLevel up your Power BI skills this month - build one visual each week and tell better stories with data! Get started
Hey,
As we have conditional formatting in tables, can we do similar in KPI?
I have to show a color bar using a meausre, when it's >= 100% then Green, when it's <100% then Red.
I tried using table for the bar, but it doesn't show background color of the meausre until n unless i add a column to the table.
And i can't create a blank column as i am using Live connection.
Anything that i can try?
thanks in advance 🙂
Solved! Go to Solution.
I found a solution.
You can import visual Advance card from market place.
Pull you measure into it and go to Conditions into column formatting.
I had two conditions, to show Green color bar for when value is >=100% and Red for the rest.
So, i chose no of conditions = 2
and turned on Data lables
And similarly for Red.
Now turn on the fill condition and it's done.
I found a solution.
You can import visual Advance card from market place.
Pull you measure into it and go to Conditions into column formatting.
I had two conditions, to show Green color bar for when value is >=100% and Red for the rest.
So, i chose no of conditions = 2
and turned on Data lables
And similarly for Red.
Now turn on the fill condition and it's done.
Check out the April 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.