Power BI Modelling & DAX: Custom Sorting to Power BI Visuals with DAX DataTable Functions
In power BI report developments, how to custom sort Table or Matrix visual by row fields or Chart by Axis etc. are often faced questions scenarios when we make a report visual. In this video I am using the Matrix visual sorted by row fields as example, and demonstrate a suggested approach by first creating an additional DIM table which has the column order index to link the targeted Attributes in the table, then make it’s relationship with the relevant table, and finally use column tools “sort by column” feature to realize the custom sorting in matrix visual. The DIM table creation is done by DAX expression in this videl but it can be also be created by power query. The custom sort approach created in the video can be also extended for sorting other visuals as well.
References:
DATATABLE function - DAX | Microsoft Learn
https://learn.microsoft.com/en-us/dax...
DAX Codes can be found from the following my blog post link:
https://mikeyubianalytics.blogspot.co...
