Forum Discussion

prasanthmagizh's avatar
prasanthmagizh
New Member
1 year ago
Solved

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
Need Help
  • sjoerdvn's avatar
    sjoerdvn
    1 year ago

    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. 

     

v-achippa's avatar
v-achippa
Community Support
1 year ago

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

v-achippa's avatar
v-achippa
Community Support
1 year ago

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