Forum Discussion
Sorting by another column - unique id - please help
[Reporting Category] should be sorted by [Reporting Category sort order]
[Reporting Subcategory] should be sorted by [Reporting Subgroup Sort Order]
Also, If your Reporting Subcategory column contains unique values (it looks like it does), then you can just use Reporting Subcategory column as the active relationship between this table and your fact table, instead of creating the Key column.
If you would like, you can send me a private message, or post here, a sample .pbix file with these two tables and as much data removed as you need to ensure your organizational security. I will solve the problem and return the .pbix file with the solution implemented.
[Reporting Category] should be sorted by [Reporting Category sort order]
[Reporting Subcategory] should be sorted by [Reporting Subgroup Sort Order]
Also, If your Reporting Subcategory column contains unique values (it looks like it does), then you can just use Reporting Subcategory column as the active relationship between this table and your fact table, instead of creating the Key column.
If you would like, you can send me a private message, or post here, a sample .pbix file with these two tables and as much data removed as you need to ensure your organizational security. I will solve the problem and return the .pbix file with the solution implemented.
i didnt realize actually sorting the categories in power query would help. Thank you so much for your help!!