Forum Discussion
Dynamic conditional formatting for gauge tile
I have a gauge tile where I am tracking percentage of revenue achieved vs budget. I want to do conditional formatting so that the gauge turns from red to yellow when we reach 80% achieved and then to green when we have reached 100% achieved. Is this possible because the only way I can find to do this is by manually entering the numbers but I want them to change when each individual year is selected.
On a separate note, is it also possible to set the guage maximum to be either the higher of the budget or the actual number if what is achieved is higher than the budget? I can set it to dynamically change by just the budget number but not to be increased if the actuals are higher.
8 Replies
Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to work with. Please show the expected outcome.
On your second question - you can use the MAX() function for that. It accepts two parameters and will return whichever is larger.Hi NikkiSavage
Have you solved this question with lbendlin's help? If you have solved the question, you can accept the answer helpful as the solution or share you method and accept it as solution, thanks for your contribution to improve Power BI.
If you need more help, please provide more details,
(1) a sample file, you can replace raw data with bogus data to protect your privacy.
(2) or provide some sample data that fully covers your issue/question
(3) give your expected result based on the sample you provide
Kindly note: Please ensure the data in sample is concise and representative.
Thanks.
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Hi
This hasn't solved my problem unfortunately. The below is a snapshot of what I have right now:
The consulting revenue data comes from the budget workbook and the transposed data workbook (which is actuals).
What I want is for the gauge to change colour from red to orange once 80% of budget has been reached and then green once 100% has been reached.
I also want the gauge maximum to change to be the higher of either budget consulting revenue or actual consulting revenue. There is no option to put a Max formula in the "Maximum Value" field so not sure what to do here. I considered doing a separate calculation within the data but I would need it to sum across the years (i.e. all of FY2022 and all of FY2021) rather than sum the maximum of either on a monthly basis.
Thanks
Nikki
Hi NikkiSavage
(1) "What I want is for the gauge to change colour from red to orange once 80% of budget has been reached and then green once 100% has been reached"
create a measure [Color], then put it into the Format pane of that visual, here is a related question, link.
(2) "I also want the gauge maximum to change to be the higher of either budget consulting revenue or actual consulting revenue. "
Create a measure [gauge maximum], in this measure create two variables to get budget consulting revenue and actual consulting revenue, then compare the two variables and return the maximum value
If you need more help, please provide more details,
(1) a sample file, you can replace raw data with bogus data to protect your privacy.
(2) or provide some sample data that fully covers your issue/question
(3) give your expected result based on the sample you provide
Kindly note: Please ensure the data in sample is concise and representative.
Thanks.
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
