Forum Discussion

FXFelix's avatar
FXFelix
Resolver I
1 year ago
Solved

Sort multiple level row header in matrix

Hello,   I want to achieve the following presentation with a matrix :   (these are row headers)   I cannot find a way to sort the second level by alphabetical order đŸ˜¶   I have tried th...
  • FXFelix's avatar
    FXFelix
    1 year ago

    I've found a trick to solve my problem: I add a space after the word if I have duplicates.

    This way, I can sort the labels by the sort keys.

    A bit far-fetched, but in my case it works...

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi FXFelix,

Thanks for reaching out to the Microsoft fabric community forum.

It looks like you are trying to find a way to sort the second level row header. As DataNinja777 has already responded to your query and you have acknowledged his response and needs some time to go through the response, kindly update the status of the issue whenever you get the chance to go through the provided response.

 

I would also take a moment to thank DataNinja777, for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

 

If I misunderstand your needs or you still have problems on it, please feel free to let us know.  

Best Regards,
Hammad.
Community Support Team

 

If this post helps then please mark it as a solution, so that other members find it more quickly.

Thank you.

FXFelix's avatar
FXFelix
Resolver I
1 year ago

Well...I guess I have another difficulty đŸ€”

 

The values of the matrix are two columns like that :

 

CA = 
VAR __CAType = SELECTEDVALUE ( FPX_Hierarchie[CA Type]; "Non sélectionné" )
VAR __Categorie = SELECTEDVALUE ( FPX_Hierarchie[Categorie]; "Non sélectionné" )
RETURN
    IF (
        __CAType = "Non sélectionné" || __Categorie = "Non sélectionné";
        // DĂ©bogage visuel
        "SĂ©lection manquante : " & __CAType & " / " & __Categorie;
        // Sinon, exécuter le SWITCH :
        SWITCH (
            TRUE();
            __CAType = "CA Comparable" && __Categorie = "Intégrés"; [CA_FPX_COMP_INT];
            __CAType = "CA Comparable" && __Categorie = "Masters Franchisés"; [CA_FPX_COMP_MASTERS_FRA];
            __CAType = "CA Total" && __Categorie = "Intégrés"; [CA_FPX_TOT_INT];
            __CAType = "CA Total" && __Categorie = "Masters Franchisés"; [CA_FPX_COMP_MASTERS_FRA];
            __CAType = "CA Total" && __Categorie = "Franchisés"; [CA_FPX_TOT_FRA];
            BLANK()
        )
    )

 

Therefore, I cannot link this with the new column CompositeCategorie...

 

Is there is another way to do it ?

 

Thanks !

  • FXFelix's avatar
    FXFelix
    Resolver I
    1 year ago

    I've found a trick to solve my problem: I add a space after the word if I have duplicates.

    This way, I can sort the labels by the sort keys.

    A bit far-fetched, but in my case it works...