Column averages table with ascending values and dynamic date slicer

Hi everyone,

I have a table that contains data with daily values like this:

Now I want to create a table with the averages in ascending order that adjusts itself when moving the date slicer in my dashboard.
I know that the treemap visual works in a similair way in my dashboard, but my customer wants a table view.
On the left of my treemap visual you can see 3 failed attempts:



It must be dynamic, so when I slice for a different period in time, my table needs to adjust.
The averages need to be dynamically sorted from highest value to lowest (just like the treemap does).
The first attempt is with a table visual, but this doesn't allow me to get my columns as rows.
The second attempt is the matrix visual, but here I can't have my values sorted in ascending order.
The third attempt is a calculated column but this doesn't adjust with the slicer (see more info below)

This sounded simple but it seems like this is not that easy on power bi... 🤔

The calculated table I made has been made like this:

But tables made like this are not affected by slicers. 😔

Is there someone who can help me with this seemingly simple problem?

Here is my pbix file: Column_averages_table_ascending_values_with_date_slicer.pbix

And here are some data files:

• Heatmap Data 1
• Heatmap Data2

Thanks in advance,
Marty