Forum Discussion
Conditional Formatting based on two conditions
I would recommend doing this in Power Query. Create first a conditional column for your first case (Access Level Text). Then you can create a custom column to combine the logic with those results and Text.Contains (see documentation here). The outcome to place in each clause will depend on you, you can directly add a hex code to represent a color or you can even show characters (see how here ).
Regarding your second question, you can achieve it through bookmarks: create 2 visuals: one with the conditional formatting and one without it. Then show one visual and hide the other and save this state in a bookmark, then do viceversa to capture the other state.
I would recommend doing this in Power Query. Create first a conditional column for your first case (Access Level Text). Then you can create a custom column to combine the logic with those results and Text.Contains (see documentation here). The outcome to place in each clause will depend on you, you can directly add a hex code to represent a color or you can even show characters (see how here ).
Regarding your second question, you can achieve it through bookmarks: create 2 visuals: one with the conditional formatting and one without it. Then show one visual and hide the other and save this state in a bookmark, then do viceversa to capture the other state.