Forum Discussion
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
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.
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.