Forum Discussion
Pklu
1 year agoFrequent Visitor
Custom Formatting
I have a table with the following fields and values: Projected Amount Actual Amount Varience $45 $50 -$5 $150 $50 $100 $400 $600 -$200 $165 $200 -$35 $75 $50 $25 ...
- 1 year ago
Is your variance amount from a measure?
You would just apply the rules like this to the background of the Variance field:
jdbuchanan71
1 year agoSuper User
Pklu ,
You can apply conditional formatting to the field based on the value like this:
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting
- Pklu1 year agoFrequent Visitor
I tried all that. They were the first things I did but it did not meet my expectations.
Looking for something like this:
Projected Amount Actual Amount Varience $45 $50 -$5 $150 $50 $100 $400 $600 -$200 $165 $200 -$35 $75 $50 $25 $450 $500 -$50 To this