Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Sort Text data in Power Bi

Hi,

 

I am new to Power BI. I have one requirement to sort the data from Text.

So I have created one 'Title' text to show the selection of the filter which user has choosen.

 

The Title text is:

Title_Nokia_SW_Pipeline_Title = " PO Plan Quarters: "&IF (

ISFILTERED ( V_OPPORTUNITIES_OIF[Quarter_Name] ),
CONCATENATEX ( FILTERS ( V_OPPORTUNITIES_OIF[Quarter_Name] ), V_OPPORTUNITIES_OIF[Quarter_Name] , ", " ),
"ALL"
). 

 

But it doesn't give me quarters in sorted order. It gives me something like below. Is there any way to sort this quarter in the above formula?

Thanks!

 

 

Regards,

Poonam

  • Anonymous's avatar
    Anonymous
    7 years ago

    HI Anonymous,

     

    It seems like power bi not contains dax functions to re-sort calculation result.

     

    Regards,

    Xiaoxin Sheng

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    HI Anonymous,

     

    It seems like power bi not contains dax functions to re-sort calculation result.

     

    Regards,

    Xiaoxin Sheng

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi Anonymous,

       

      Thanks for your reply!

       

      Regards,

      Poonam