Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

July 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more

Reply
Anonymous
Not applicable

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 

2 REPLIES 2
eliasayyy
Memorable Member
Memorable Member

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
Not applicable

Thank you !

Let me explan more my needs

Assa23_0-1695996427043.png

 

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

Helpful resources

Announcements
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

60 days of Data Days Carousel

Data Days 2026

Join Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Top Solution Authors