Sorting Matrix without adding the row

[Mike91]

Hi All,

i need help to create a matrix, like this but i want order the matrix by the release date of item, i tried with sorting by release date in table but more items was released in the same day and i can't do that. Any idea how i can sorting the matrix without add the release date info but use this for sorting? 

[Shivu-2000 · Accepted solution]

Hin @Mike91 

According to my understanding you want to sort a Power BI matrix by the release date of an item, but you don't want to explicitly display the release date in the matrix. 

Solution would be using a Calculated Column and Sorting

1. • In your data model, create a calculated column that assigns a unique identifier to each item based on its release date. This identifier should be unique even if multiple items have the same release date.

     Create a Calculated Column:

   ReleaseDateRank = RANKX(ALL(YourTable[ReleaseDate]), YourTable[ReleaseDate])

   Replace YourTable[ReleaseDate] with the actual name of your release date column.

2. Sort the Matrix:

   • In your matrix visual, drag the calculated column ReleaseDateRank to the rows or columns (depending on your desired layout).
   • Sort the matrix by this calculated column in ascending or descending order.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Happy to help!

[Mike91]

Thanks for the help, when i drag the rank value i need to a drill to see the item but near of them remain the rank value, it's possible hide them?