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.
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:
Create a variable that calculates the Maximum value reached per Lake, which I named MaxCapacity.
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.