This is a short description on how I solved the #wow2021 Power BI challenge (released on May, 12th 2021). Here you will find a short description of the challenge: 2021 Week 19 | Power BI: Can you Highlight Values Using DAX? – Workout Wednesday (workout-wednesday.com)
Here you will find my pbix: https://tommartens-my.sharepoint.com/:f:/g/personal/tom_minceddata_com/Ei3TnNTKa2pBooYMe5BvSAwBWJ_DG9Kp6VjwcAlJpUSGpw?e=5zgwDO
This time the challenge was relying on using DAX.
DAX was used for two things
- The measure that creates the highlight
This measure returns the current value if this value matches the Minimum or the maximum value. Here we have to consider that the existing filter applied through the axis will be removed (blocked) to determine the min/max values. This measure returns the current value if this value matches the Minimum or the maximum value. Here we have to consider that the existing filter applied through the axis will be removed (blocked) to determine the min/max values.
- DAX based calendar table
If you are using DAX to create the calendar table, then the column is Month Year is created, it is necessary to notice that the month is represented by a date. This allows using the continuous type for the x-axis. Read this article for more details: Improving timeline charts in Power BI with DAX - SQLBI
I also added a disconnected table to the dataset that allows selecting the measure to be visualized. For this reason there is a measure called “SelectedMeasureValue”. This measure returns the current value for the selected measure.
This measure is referenced inside the measure “vizAid Min/Max Highlight”, this measure basically checks if the current value matches either the minimum value or the maximum value. If this is true the current value is returned otherwise this measure returns null.
Highlighting the minimum and maximum value basically is not a highlighting, instead all the other data labels are hidden. This is possible as data labels and the markers can be customized per series 😊