Power BI 2021 Workout Wednesday for Week 7

The Workout Wednesday (#WOW21) for the 7th week of the year 2021 aimed to challenge participants on conditional formatting for the matrix visualization. I enjoyed the Data transformation - which needed the UNPIVOT function and learnt few techniques on conditional formatting the Matrix.


WOW Challenge Original Viz:

My own version:

What did I do differently:

The original report (dashboard!) responded to the question Which lake has frozen completely over most often? using a simple bar chart entitled Maximum Historical Coverage shown in the first figure. However, the drawback of this bar chart is that it only shows the maximum capacity ever reached but it doesn't readily shows how often.

To illustrate how often the maximum capacity was reached, I incorporated some card visuals, which then shows, for example, how many times did Lake Erie reached the maximum capacity.


The interesting process of creating the cards:

This was my moment to practice DAXing. The process of creating cards involved some DAX formulas which did the following:

  1. Create a variable that calculates the Maximum value reached per Lake, which I named MaxCapacity.

  2. Count the instances of the above variable per lake, which I named Max Count.

As a result, 5 DAX measures were created for each lake in the below format:




Happy WOWing and DAXing, Out.




34 views0 comments

Recent Posts

See All

This week's Wednesday work-out challenge aimed to challenge Power BI designers to utilize the recently released Page Navigation features. The new features were released in the November 2021 Power BI

Happy new year and wish a productive, prosperous and healthy 2022 to all!! Microsoft continues to prove why Gartner has been recognizing Microsoft as a Magic Quadrant Leader in analytics and business

Few months ago, I was busy searching for a solution to filter data points on a map based on a variable-distance. This was in response to a need for a dynamic dashboard in my production environment to