cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper IV

## Sort by Changes Measure Results

Hello,

I have a report that shows sales totals for different categories, as well as the amount and percent change from the most recent date to the other dates. This is what my visual currently looks like:

The measures that make up the visual are the following:

``````Total = SUM('Table'[Amount])

Change from = CALCULATE([Total],'Table'[Date]=MAXX(ALL('Table'[Date]),[Date]))-[Total]

% Change from = DIVIDE([Change from],CALCULATE([Total],'Table'[Date]=MAXX(ALL('Table'[Date]),[Date])))``````

The issue with my visual in it's current position is that I need the most recent date to be on the left, with the date sorting descending from left to right instead of ascending from left to right. I created an Index that will sort the dates in descending order, but when I sort the dates, my visual turns into this:

I have tried to follow the instructions explained in this post: https://blog.crossjoin.co.uk/2015/12/15/power-bi-desktop-sort-by-column-and-dax-calculations-that-us...  , but it doesn't end up changing anything. After changing the measures to follow the post's instructions, they look like this:

``````Total = SUM('Table'[Amount])

Change from = CALCULATE([Total],'Table'[Date]=MAXX(ALL('Table'[Date], 'Table'[Index]),[Date]))-[Total]

% Change from = DIVIDE([Change from],CALCULATE([Total],'Table'[Date]=MAXX(ALL('Table'[Date], 'Table'[Index]),[Date])))``````

Any help would be greatly appreciated! Thank you in advance!

0 REPLIES 0

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors