Please Solve this problem

[N_Kotiyal]

Hi All,

I want to sort the age group acsending like 1-30 comes first ,31-60 second column rest like wise .
remember this is the direct query.

[v-tangjie-msft]

Hi @N_Kotiyal ,

You have to sort this in SSAS model itself as direct query does not have the ability to perform sorting.

Please note that this is for SSAS tabular model (assumes that you already created a model and connected online to PowerBI)

You have to do the sorting in SSAS tabular model using visual studio. For this, select the table and column to sort and click the button "Sort By Column".  This will give you the option to "Sort By" a particular column that need to sort.

Click OK and process the model and re-deploy it to see the results in Power BI

Choose Sort By column :

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[ryan_mayu]

@N_Kotiyal 

not sure if we can use grouping and binning for direct query

Use grouping and binning in Power BI Desktop - Power BI | Microsoft Learn