How to Red Flag certain indicators

[CameronDHussey]

Hey guys, I'm fairly new to Power Bi but understand the basics. To cut to the chase i'm wanting to create a visual/report that picks a filter from an established Google Doc values. Example

Accounts Recievable

Sales Numbers

Quantity Sold.

Google Doc where I define Acceptable Rate: Example:

Accounts Recievable = 200,000

Sales Numbers = 1,600,000

Quantity Sold = 2,000,000

And my report/visual will only show these if and only if the current numbers exceed this/or are below. What I would call a 'Red Flag' Report. 

I'm sure there are many ways to do this but basic idea is that a general manager or regional manager can update his 'target' numbers. And my report pull that data and red flag when they get off track. 

Any suggestions?

[VahidDM]

HI @CameronDHussey 

You need to use a Waht-if parameter to define the target:

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-what-if

and then use the output of the What-if parameter to create a another measure to check the values and if it's more than the target shows 1 otherwise 0, then apply a conditional formatting for that field.

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/