shannonrlindsay
Advocate III
Advocate IIIWorkout Wednesday 2024 | Week 3
Join us this week to create a bar chart in Power BI. This is a great challenge to try if you're learning Power BI. It includes some simple visuals and a bit of DAX to accomplish conditional formatting. Find the entire challenge over at Workout Wednesday.
The measure I used for my conditional formatting is:
Format max value =
VAR MaxValue = MAXX(ALLEXCEPT(Resolutions_Unpivoted, Resolutions_Unpivoted[Category]), [Avg Value])
RETURN IF([Avg Value] = MaxValue, "#5D8099", "#CCCCCC")
No RepliesBe the first to reply