New DAX Function for Visual Level Calculation RANK()💡| Sort Matrix visual based on Multiple Columns

Have you noticed a New DAX function RANK() with latest version of Power BI desktop.?. This Function's argument is similar to other 3 WINDOW dax functions, and can be used for visual level calculations.
I will present how we can utilize this to apply multi column sort order for your Matrix visual.

Get Help into Questions Related to #powerbi , #dax , #powerquery Power BI #datamodeling , #analysisservices and #powerbiservice

Follow us on LinkedIn
@PowerBIHelpline

[arunmohan]

It was a very helpful video, dude. My search for blogs and videos about this scenario turned up nothing. I am very grateful to you. keep up the great work.

[charnettebloomer]

Thank you!! I have been trying to solve this issue for a year and a half. Maybe I am doing something wrong, but renaming the field to blank reverts back to what was originally there.

[rakshitharamesh]

This was really useful, Thank you! How do I add a dynamic parameter that restricts the results of Rank on the Year level?

[sr]

Awesome. Could you please make a video on how to use Rank to sort based on a list of values? Eg rankx -- The third argument of RANKX is useful when the outer
-- evaluation requires a different expression than the
-- inner one. For example, when ranking an expression over
-- a pre-built lookup table
DEFINE
VAR SalesLevels =

EVALUATE
ADDCOLUMNS (
VALUES ( Product[Brand] ),
"Sales Amount", [Sales Amount],
)
ORDER BY [Level] ASC


2. How to do approximate match lookup in powerbi

[OOuulala]

Hello, this is a great video and I feel I am almost there with what I want to do with my matrix, which is the same as shown in your video, only that I want to sort by a date, then by another date. However, I cannot go pass the ALLSELECTED syntax. How can I get further help?

[narendrababu]

Hello power bi helpline.

I had a requirement, if possible can you do this as a video. I had IoT data for 1hr data. I am using direct query mode. In xaixs i am using time stamp hh:mm:ss format. So when ever new data comes the xaxis need to be dynamic. Example, in xaxis data starts from 1:24:10 and ends with 1:26:30. When the new data comes it should be 1:25:15 and end is 1:27:46. Xaixs need to be dynamic with 2min interval. Xaxis is need to be moving. How can we achieve this?

[ameersuhelkhan]

Awesome solution using #RANK() function? Since when this function exists?

[pranaybharath]

is ABC analysis better to be done with Rank or windows function?