Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.