Forum Discussion

Alirezam's avatar
Alirezam
Helper V
7 years ago
Solved

No refreshment on date orders

Hi guys,   I reckon it's rather a simple question but I cannot fix it: Month order on my x-axis works properly (Jan-Feb-....Dec) But after publishing the report, when I open it on Power Bi servic...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi Alirezam 

    The sort order keeps in Power BI Service on my side.

    My method is as below:

     

    1. This is my date table

       Create column here

    month = MONTH([Date])

month name = FORMAT([Date],"mmm")

     

    2. Select "sort by month name"

     

    3. Click on "month name" column, then select "sort by column"->"month".

     

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi Alirezam 

The sort order keeps in Power BI Service on my side.

My method is as below:

 

1. This is my date table

   Create column here

month = MONTH([Date])

month name = FORMAT([Date],"mmm")

 

2. Select "sort by month name"

 

3. Click on "month name" column, then select "sort by column"->"month".

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.