Unlock Hidden Insights with DAX: Create Best-in-Category Metrics Easily! @chandoo_
Unlock Hidden Insights with DAX: Create Best-in-Category Metrics Easily!  @chandoo_
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
Unlock Hidden Insights with DAX: Create Best-in-Category Metrics Easily!How to make a Column Chart with TOTALS in Excel (perfect for data analysis)Learn SQL + Database Concepts in 20 Minutes35 Must have Excel ShortcutsExcel Data Cleaning TrickπŸ’‘for uneven rows of data #EXCELPower Query MAGIC! ⚑Auto-Categorize Text Like a PRO!Stop Dragging in Excel, there is a BETTER way!UNPIVOT: Data Cleaning Power Tricks πŸ’‘Powerful trick to get data from any folder in Excel (works even after renaming!)Excel formula to get CLOSEST Matching ValueIntroducing Free Data Analyst Course - SQL / Excel / Power BI / Python3 Things I do in my new Job to Succeed as a Data Analyst
Chandoo |

Unlock Hidden Insights with DAX: Create Best-in-Category Metrics Easily!

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER