Forum Discussion
Power BI Table visual - Sorting by Region, Status
Hello All, We have a Training Status Report in which we display region wise employee training completion status. Our client want this report should be sorted by region then status. How ...
Hi Anonymous
you can try sorting two ways in Power query.
step1: open power query sort the region by Asc.
step2; sort the status by asc again
Step3 : then add index
Step4: save and close
then select your Region column > sort by column > index
your table will be sorted based on you index values.
I hope I answered your question!
Hi Anonymous
you can try sorting two ways in Power query.
step1: open power query sort the region by Asc.
step2; sort the status by asc again
Step3 : then add index
Step4: save and close
then select your Region column > sort by column > index
your table will be sorted based on you index values.
I hope I answered your question!