2021 Work-out Wednesday Week 8: Power BI: SWITCH()ing Measures

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?


  1. 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.

  2. 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?

  1. 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.

  2. 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







8 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