PowerBi Matrix table - sort by month and value

[illusionek]

Hello

I am using Matrix table and the challenge I am facing is that I want the table to be sorted by Month like in below example starting with lowest value but then I would like data to get sorted by value starting with larges. Based on the below example month 1 and 2 are fine but this is just a coincidence. Now I would like to achieve the same sorting for month 3. I have tried multiple ways and spend ages on google but I am unable to find a solution.

Any ideas?

Link to sample data below

PowerBi Sample.pbix

 

[RoryA]

I don't believe you can, sadly.

 

[JEC]

There is way via Power Query. Create a copy of your table and put this M-code in the advanced editor (only change the source line to suit)
It creates a grouped table and add index numbers to the region. (maybe the second step is not necessary at your machine)

let
    source = yourpath,
    rep = Table.ReplaceValue(source,",",".",Replacer.ReplaceText,{"Total Value"}),
    cTypes = Table.TransformColumnTypes(rep,{{"Total Value", type number}}),
    grp = Table.Group(cTypes, {"Region", "OrderDate - Month"}, {{"Aantal", each List.Sum([Total Value])}}),
    sort = Table.Buffer(Table.Sort(grp,{{"OrderDate - Month", Order.Ascending}, {"Aantal", Order.Descending}})),
    grp2 = Table.Group(sort, {"OrderDate - Month"}, {{"Aantal", each Table.AddColumn(Table.AddIndexColumn(_,"index", 1),"Region_t", each Text.From([index]) & "." & [Region])}}),
    expand = Table.ExpandTableColumn(grp2, "Aantal", {"Aantal", "Region_t"})
in
    expand