Forum Discussion
Conditional Formatting - how to keep context with slicer?
I am using the new conditional formatting for tables feature - looks great.
And....
I want to be able to use this with a slicer, which presents a challenge.
In the initial "unfiltered" scenario, I have a table that shows 100 projects. Using the "Conditional Formatting > Diverging" option - I am able to generate a nice visual that shows which of the 100 projects are "high risk" (now showing red).
Perfect so far.
However, if I use a slicer to select one project, the conditional formatting ignores the initial context of generating the conditional formatting relative to the other 100 projects. Instead, when the single project is selected - all conditional formatting fields turn "Red", The conditional formatting logic is now only applying to the selected project. Not perfect - as the project is really not "red" relative to the other 99 projects.
Is there any way to set this to retain the intial context (i.e. conditional formatting relative to the initial set of 100 projects), or is there a way to invoke DAX to set the context?
Anyone have a solution?
Virtual_Ames In conditional formatting if instead of using Lowest Value and Highest Value, you use Number to set colours for both Minimum and Maximum, it will work when you filter out one project using slicer.
2 Replies
Virtual_Ames In conditional formatting if instead of using Lowest Value and Highest Value, you use Number to set colours for both Minimum and Maximum, it will work when you filter out one project using slicer.
Thanks - this does this trick. Have a good one.
