PowerBI Sorting issue for Rows with Matrix

[Paf50]

Hello, having issues Sorting within a Matrix. I have a field named "Sort". What it does is sorts By date the Category/SubCategory/Element so that they are continuously in the same order each time I get new records flowing in daily. Please see that I brought the "Sort" field in to Values in to order to sort but the issues is that anytime a new day's worth of data flows in, the column I brought for Sort shows up. I want it completely hidden. So maybe I'm going about this completely wrong. Is there a better way?




So as new dates flow into my matrix, I am forced to hide the sort column each time. I dont want to have to do this.


ThanksPatrickDeveloper

 

[Matt Allington]

Click on the element column in the table, from the menu, find the sort by column button and change the sort order to refer to your sort column. This overrides the default sort order of the elements column. you need a specific sort column for every text column that you don’t want to sort alphanumeric.

 

[Paf50]

Click on the element column in the table, from the menu, find the sort by column button and change the sort order to refer to your sort column. This overrides the default sort order of the elements column. you need a specific sort column for every text column that you don’t want to sort alphanumeric.

Do I remove the “Sort” field from the Values? If so, where do I place it?

 

[Peter_SSs]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: PowerBI Sorting issue for Rows with Matrix
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.