Sorting of column in Datamart not showing in Desktop Report

[Steph_Aust]

I have setup some data in a Datamart, set the sort order for a couple of text columns to another numerical column. When connecting to the datamart with the Desktop app the sort order is not showing up. It is the same when connecting to the data using the web based app. It seems that this feature of the Datamart is not working and there is no ability to adjust the sort order in the report (web or desktop)

[Steph_Aust · Accepted solution]

I was using a Pie Chart and just wanted the text names to be displayed in a specific order. I have done this in the past using the desktop app. In the desktop app i would create a dimension table that had the text values and the sort order. Then i would create a relationship between the dimension table and my fact table. 

I have not been able to get this to work the same way in the Datamart. In the Datamart i had three different fact tables that i wanted to conect to the Dimension table. When i setup the dimension table and created the relationships it would only work properly for one of the fact tables and give me an error when i was trying to setup the relationship in the other fact tables. 

In the end I have updated my queries in the datamart to get the sorting column as part of the Fact tables rather than trying to create a relationship to a dimension table. 

[v-jayw-msft]

Hi @Steph_Aust ,

What visual you are using? Can you share some screenshots?

Best Regards,

Jay