Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Filter

Hello all, 

i need to filter by spécifique term. 

For exemple : My table is "Compt" with columns "Ac" and rows "Ad" , "Com" & "Val" with values : "12", "14" & "78

I want to filter by this spécific order like  "Com", "Ad" & "Val"

 

Someone can help me for the dax syntax i can use ?§! thank you 

Need Help

2 Replies

  • eliasayyy's avatar
    eliasayyy
    Memorable Member
    2 years ago

    hello you mean you need to sort, if its a visual table on your visual or bar chart or whatever chart, just press the 3 dots and choose sort axis by the values and desencding

    for your main table in dataset, go to the table view where you see your table in dax, click the Compt column and in column tools in your ribbon , press on sort column by, and choose the values option , this will auto sort the compt column based on values

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Thank you !

      Let me explan more my needs

       

      I have this matrice graphique i would like to filter by "Compte" to have to first position Com, Val & AC not to filter by the values. 

      I try to use Order by, but it isnt work