Forum Discussion
Solved
Conditional Formatting in Tables with the Same Underlying Dataset and Different Filter Context
I am very new to Power BI, and so I apologize for any obvious mistakes here. I'm working on creating a Power BI dashboard where a user can use slicers to select two model numbers from a database,...
Sam_Jask You can't use a calculated column as those are not dynamic, you would need to use a measure and I would suggest a measure that returns "#FF0000" or "#00FF00" and build all the logic into the measure.
Hi Sam_Jask ,
I agree with Greg_Deckler, calculated column could not be dynamic. I suggest you to create a measure to achieve your goal.
Your calculation is based on your data model. For further help, I suggest you to share a sample file with us and you can show us a screenshot with the result you want.
This will make it easier for us to find the solution.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.