Color code a variance

[nrocha]

Hi all,

I need help walking through an issue. I'm tracking hours by estimated hours vs actual hours and I want to color code the variance. Green if its within the budget, yellow if the variance is over 5% and red if its over 10%. Does power BI do this or is there a work around?

Thanks

[v-yuta-msft]

Hi nrocha,

Based on your description, may be conditional formatting can meet your requirement, pleae refer to: https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting. However, if still can't achieve what you want, could you share some sample data for further analysis?

Regards,

Jimmy Tao

[Greg_Deckler]

In theory, you could create a measure for this, but would need sample/example data and expected output to be specific.