Can't sort column using index or rankx power bi database

[Anonymous]

I need to sort a stacked bar chart by age group. I've used the methods of creating a separate table to sort, and index column to sort column order by, and rankx to create another column to sort by. These have all worked in the past but not now. The only difference I can guess is that this time I am using power bi database as my data source. Does anyone know a way around this problem?

[v-jingzhang]

Hi @Anonymous 

Does @harshnathani 's solution solve your problem? It should work. I connected to this dataset after publishing it to service, and created some visuals to check the sort. It worked well at my side. Let us know your result. Thanks.

Regards,

Community Support Team _ Jing Zhang

[Anonymous]

Here's the pbix. Hopefully, it helps!

https://drive.google.com/file/d/1Y8G4XznDIxZEwfe1QrPL5JNWAaSKj8Dq/view?usp=sharing 

[harshnathani]

Hi @Anonymous ,

Have sorted the age category column by index and then created the visual again.

Let me know if this is what is needed.

pbix attached.

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[v-jingzhang]

Hi @Anonymous , can you share some dummy data or PBIX file (remove sensitive info) which can help reproduce this issue? Thanks.

Regards,

Community Support Team _ Jing Zhang

[parry2k]

@Anonymous ok, not sure where the problem is, I would recommend sharing sample pbix file (remove sensitive info before sharing) and also the expected output, it will help to provide the solution. 

[parry2k]

@Anonymous well you have to apply this sorting method in Power BI dataset you are connecting to. So basically get this change made in the Power BI data model.

Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[Anonymous]

Yes. I thought I had explained that I had already done that but it is still not working. I have applied all of the previously mentioned methods to the database, but it is not working.