Uploaded March 2023 | Updated November 2026, 3 hours ago
In this video, you'll learn the insider secrets to calculating best in category rankings like a pro using DAX. Whether you're a business analyst, data scientist, or just someone who loves working with data, this tutorial will give you the tools you need to take your analysis to the next level.
We are going to learn how to use MAXX and ALLSELECTED to calculate the maximum or best in a category and use conditional formatting to highlight the value in the visuals.
You are also going to learn how to use sneaky field format option to colour the graph thru DAX π²
β± In this video:
=============
0:00 - Best in category with DAX - a demo of the solution
1:20 - Creating a small-multiple graph in Power BI
2:26 - Generating the Best in Category DAX
5:17 - DAX for colouring the graph based on best in category.
7:16 - Applying conditional formatting rules
π Practice Workbook
===================
You can apply this concept with any of your datasets. Here is a sample dataset for you try -
chandoo.org/wp/wp-content/uploads/2022/09/sample-data-10mins.xlsx
Master DAX - My Videos on the topic π©βπ»
================================
Beginner to PRO DAX video - youtu.be/PQ5lALdFHCU
Difference between New Measure and New Column, This is important - youtu.be/kgNbWOCuRCE
Different calculation for Subtotal with DAX - youtu.be/n7gAJMBdJ8k
My Power Pivot Playlist - youtube.com/watch?v=n7gAJMBdJ8k&list=PLmejDGrsgFyCm0i58VobdriBr--FA8lYh
Full Power BI Course - chandoo.org/wp/power-bi-course
~
#powerbi
In this video, you'll learn the insider secrets to calculating best in category rankings like a pro using DAX. Whether you're a business analyst, data scientist, or just someone who loves working with data, this tutorial will give you the tools you need to take your analysis to the next level.
We are going to learn how to use MAXX and ALLSELECTED to calculate the maximum or best in a category and use conditional formatting to highlight the value in the visuals.
You are also going to learn how to use sneaky field format option to colour the graph thru DAX π²
β± In this video:
=============
0:00 - Best in category with DAX - a demo of the solution
1:20 - Creating a small-multiple graph in Power BI
2:26 - Generating the Best in Category DAX
5:17 - DAX for colouring the graph based on best in category.
7:16 - Applying conditional formatting rules
π Practice Workbook
===================
You can apply this concept with any of your datasets. Here is a sample dataset for you try -
chandoo.org/wp/wp-content/uploads/2022/09/sample-data-10mins.xlsx
Master DAX - My Videos on the topic π©βπ»
================================
Beginner to PRO DAX video - youtu.be/PQ5lALdFHCU
Difference between New Measure and New Column, This is important - youtu.be/kgNbWOCuRCE
Different calculation for Subtotal with DAX - youtu.be/n7gAJMBdJ8k
My Power Pivot Playlist - youtube.com/watch?v=n7gAJMBdJ8k&list=PLmejDGrsgFyCm0i58VobdriBr--FA8lYh
Full Power BI Course - chandoo.org/wp/power-bi-course
~
#powerbi










