Forum Discussion
How to Red Flag certain indicators
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?
1 Reply
- VahidDM
Super User
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/
