Forum Discussion
Conditional Formatting - Slicers
Good morning everyone, I'm having an issue regarding the conditional formatting of my table based on Slicers selection. Let's say I have 1 slicer with 3 differents options (X, Y or Z) and a ...
How is your conditional formatting expression defined? You need to make sure the context transition it is performed and the filter context is taken into account.
You have a detailed explanation in the following article:
https://insightsquest.com/2018/08/18/expression-based-conditional-formatting/
If you still have issues, give us more details about your conditional formatting.
Regards,
Thanks for the link I'm still going over to understand the logic.
Basically my tool applyies for the aviation industry, I have a specific slicer with three options:
Takeoff - Climb - Cruise.
I also have a table in which I can see for example the Oil Pressure which the value depends on the phase of flight selected.
I would like to apply a conditional formatting based on a certain threshold that would be linked to the phase of flight applied.
I've tried to play with the rules in conditional formatting but it does not care about what option is selected and apply the rule for all the three options.. I obviously can't create a column specific for one parameter and one phase of flight because that would take me too long.
If anyone can give me a hand on that, it would be really helpful !!
Basically my tool applyies for the aviation industry, I have a specific slicer with three options:
Takeoff - Climb - Cruise.
I also have a table in which I can see for example the Oil Pressure which the value depends on the phase of flight selected.
I would like to apply a conditional formatting based on a certain threshold that would be linked to the phase of flight applied.
I've tried to play with the rules in conditional formatting but it does not care about what option is selected and apply the rule for all the three options.. I obviously can't create a column specific for one parameter and one phase of flight because that would take me too long.
If anyone can give me a hand on that, it would be really helpful !!
Hi Anonymous,
To make your requirement more clear, please illustrate your scenario with sample data and desired output.
How to Get Your Question Answered Quickly
Regards,
Yuliana Gu
