The eighth version of the 2021 #WorkoutWednesday was a step up from the previous ones, which were merely drag and drop #visualizations. This version needed to crack some #Switch( ), #SelectedValue, and more of DAX formulas to achieve the results and due to this elevated complexity I could not complete the work-out without peeping into the solution.
What I managed to do before peeping into the solution?
I managed to set up the horizontal slicer and connected it to the measures table using SelectedValues () and SWITCH (TRUE ()) functions. I give credit to the tutorial by Vijay Perepa, which I had stumbled up before this exercise.
Managed to create the first KPI Card , Bar Chart and Area Chart, enabling color and text conditional formatting using rules.
What I could not figure out and later learnt for the solution video?
I could not figure out on how to change the size of the report page. I attempted to use the mobile layout, but it was not interactive.
I struggled to create the DAX measures for CY and PY - spent a lot of time wondering how can I do a CALCULATE that will filter on current year, with an expression from Year field of area chart. I could not think about using MAX of the year Column.
After learning from the solution, the final product:
In closing, I have learnt a a lot. Thanks to team behind the #WoW