Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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.
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
96 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |