Custom Sort in Visualizations

[derrick3883]

i created two tables at my power BI desktop version, one is called TimeTbl that contains 1/1/2018 as [data_yrmo_dt] column name, January as [Month] column name and use DAX Related() function to bring in ID 1,2,3,... from MONTH_ID table into TimeTbl. Hoping i could use the custom column ID and sort the Month in order but still unable to.

Please help

[v-piga-msft]

Hi @derrick3883,

It seems that you want to sort the Month column by the Id in another table? What order do you want to order the month? 

Normally, we could achieve custom sort by the way below.

Assuming that you have two tables like below and create the relationship.

Then you could create a calculated column with the formula below and sort column by Month_id .

Month_id = RELATED(MONTH_ID[ID])

For reference, you could have a look at this similar thread which has been solved.

If you need additional help, could you share a dummy pbix file which can reproduce the scenario and your expected output, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)

Best Regards,

Cherry