Forum Discussion
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
- Anonymous7 years ago
HI Anonymous,
It seems like power bi not contains dax functions to re-sort calculation result.
Regards,
Xiaoxin Sheng
2 Replies
- AnonymousNot applicable
HI Anonymous,
It seems like power bi not contains dax functions to re-sort calculation result.
Regards,
Xiaoxin Sheng
- AnonymousNot applicable
Hi Anonymous,
Thanks for your reply!
Regards,
Poonam