Forum Discussion

suparnababu8's avatar
suparnababu8
Icon for Super User rankSuper User
2 years ago

 

 

QuarterDate = 
DATE(
    YEAR([Date]), 
    SWITCH(
        TRUE(),
        FORMAT([Date], "q") = "1", 1,
        FORMAT([Date], "q") = "2", 4,
        FORMAT([Date], "q") = "3", 7,
        FORMAT([Date], "q") = "4", 10
    ), 
    1
) In your date table, add a calculated column that combines the year and quarter into a date format. Here’s above an example DAX formula:

  1. Use the Calculated Column in Your Visual: Drag the QuarterDate column to the axis of your bar chart. This will ensure that the bars are displayed in chronological order.

  2. Filter by Quarter: In the “Visualizations” pane, drag the QuarterDate column to the “Filters” section.

 

  • Duinhir's avatar
    Duinhir
    New Member
    2 years ago

    Thank you suparnababu8,

     

    the sorting problem is solved, and to be honest it could be fine to leave like it is.

    Is there any chance to display it instead of the months: Q1, Q2 and so forth?

    Below it's how it looks now. I chose "(yyyy-mm)" in the column format, which is the closest to what I'd like to show.

    Thank you very much for your support!

     

    Kind regards

    Fabio