Forum Discussion
Issue: Conditional formatting with different target at total level
I am trying to do a conditional formatting with different target at different level.
Current Target is set into 2 type:
1.Company level
2.Group level (All company)
Data Point:
Actual Data is from SQL
Target is from Google sheet (representing monthly target for a whole year)
From below picture, I want to do conditional formatting for each of the row respectively.
Conditional Formatting =
Company's Accuracy% >= Company Target Accuracy%, Green Font
Company's Accuracy% < Company Target Accuracy%, Red Font
Same for Group level
Actual Data.
Period = Year-Month
SKU = SKU code
Forecast = Forecast Qty
Actual = Actual Qty
ABS Error (column formula in BI) = ABS(Forecast-Actual)
Measure Accuracy (measure in BI) = SUM(Abs Error)/SUM(Actual)
10 Replies
You can do this by creating a formatting measure, something like:
Accuracy% Formatting = IF( [Measure Accuracy] > [Target Accuracy], "green", "red" )Then you can use that measure for conditional formatting in your table visual.
You'll need to choose 'Field Value' in the format style and then select the format measure.
That should apply both for company and group level, depending on which you have showing in the table
Any trouble please let me know
Ok, is there a way you could create a link between actual and target? We need to try and get to the point where for any row in the table (including the totals) we can get the value of actual, the value of target and then compare them.
