Conditional Formatting

Question

I am using the new conditional formatting for tables feature - looks great.&nbsp;&nbsp;And....&nbsp;I want to be able to use this with a slicer,&nbsp;which presents a challenge.&nbsp;In the initial "unfiltered" scenario, I have a table that shows&nbsp;100 projects.&nbsp;&nbsp;Using the "Conditional Formatting &gt; Diverging" option - I am able to generate a nice visual that shows which of the 100 projects are "high risk" (now showing red).&nbsp;Perfect so far.&nbsp;However, if I use a slicer&nbsp;to select one project, the conditional formatting ignores the initial context of generating the conditional formatting relative to the other 100 projects.&nbsp; Instead, when the single project is selected - all conditional formatting fields turn "Red",&nbsp; The conditional formatting logic is now only applying to the selected project.&nbsp; Not perfect - as the project is really not "red" relative to the other 99 projects. &nbsp;&nbsp;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?&nbsp;Anyone have a solution?&nbsp;

ankitpatira · Accepted Answer

Virtual_Ames&nbsp;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.&nbsp;&nbsp;

Forum Discussion

Related content

Conditional Formatting

Condition formatting

Conditional Formatting using DAX

Conditional Formatting