How to order months in matrix visual columns in Power BI service (not desktop)

[mhaupt]

Hi all,

Is there a way to order the month column (text format)  in a matrix visualisation in a Power BI service report? I have another field in the month reference table which is the sequential month (1,2,3 etc).   I know how to do it in Power Bi desktop, but can't see how to do it in service.  Reason I want to work in service not desktop is there is a semantic model I want to use as the basis for many reports.

[TomMartens]

Formed by pressure 🤣

[TomMartens · Accepted solution]

Hey @mhaupt ,

you can do that:

You have to enable the web-based model editing though: Edit data models in the Power BI service (preview) - Power BI | Microsoft Learn

Hopefully, this helps to tackle your challenge.

Regards,

Tom

[mhaupt]

TomMartens, you are a diamond!  Many thanks