Forum Discussion

gra_197's avatar
gra_197
Helper II
6 months ago
Solved

Slicer data

Hi, How can I get the above slicer to play ball, the months are all over the place. Many thanks
Need Help
  • cengizhanarslan's avatar
    cengizhanarslan
    6 months ago

    1) Create a Month Number column

    In your Date table:

    Month Number = MONTH ( 'Date'[Date] )

     

    2) Sort Month Name by Month Number

    • Select Month Name column

    • Column tools → Sort by column

    • Choose Month Number

Anonymous's avatar
Anonymous
Not applicable
6 months ago

Hi gra_197,

 

Just following up to see if the Response provided by community members were helpful in addressing the issue. if the issue still persists Feel free to reach out if you need any further clarification or assistance.

 

Best regards,
Prasanna Kumar