Forum Discussion
AGE BAND FORMUAL
I calculated the age band using the if formula and used the matrix visualixation
need your assistance the >50 days to last
Ok, so your source is excel.
I suggest that in the power query editor you add a conditional column, replace "> 50 Days" with "50" to get the sorting you need. Close and apply the power query changes. Then in the Data pane select the "Age
Band" column set the "Sort by Column" property to the newly added column.
10 Replies
In the table where you have your "age band" column, add another column "age band sort" then set that column as sort column for "age band".
How to add another column and what data need to be specified
You haven't shared any usefull information on your semantic model and the source of your data, so it is impossible to say what the best method is to add that column. It could be in power query, but also in a SQL view or query.
The sort column however, the actual values are not really important (you should even hide the column) , but it must have the same cardinality but the values should... sort.
for example:age age sort 0-10 Days 00 11-20 Days 11 31-40 Days 31 >50 Days 50
Ok, so your source is excel.
I suggest that in the power query editor you add a conditional column, replace "> 50 Days" with "50" to get the sorting you need. Close and apply the power query changes. Then in the Data pane select the "Age
Band" column set the "Sort by Column" property to the newly added column.
Hi prasanthmagizh,
Thank you for reaching out to Microsoft Fabric Community.
Thank you sjoerdvn for the prompt response.
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the super user resolved your issue? or let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.Thanks and regards,
Anjan Kumar Chippa
Hi @prasanthmagizh,
We wanted to kindly follow up to check if the solution provided by the super user resolved your issue.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.
Thanks and regards,
Anjan Kumar Chippa
Hi @prasanthmagizh,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the super user resolved your issue.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.Thanks and regards,
Anjan Kumar Chippa
