group dates to show anything prior to a date as one bar and the rest monthly

[hpatel24779]

Hi All,

I have done this previously but seemed to have forgotten how i did it. i know you have to group dates but not exactly sure how.

I have a dataset with date ranging from 01/04/2020 to present. I want to create a visual where i can see one bar for anything prior to 01/04/2024 shown as 'Pre-April 24' and the rest shown monthly.

How can i achieve this? Below example of what i want to show. Please can you be kind enough by giving more detailed steps to solve my problem

kind regards

Hetal

[hpatel24779]

thank you @Ritaf1983 this is exactly what i needed. also thanks for sharing pbix

[Ritaf1983]

Happy to help😍

[Ritaf1983 · Accepted solution]

Hi @hpatel24779 
You can add column to the date table for grouping with the dax = 

date group = if ([Date]<= date(2024,04,01) ,"pre april 2024", 'Calendar'[Year-Month])

+
Add sort column :

date group sort = if ([Date]<= date(2024,04,01) ,0, 'Calendar'[Year-Month Code])

Sort the first column by the second :

from here create a graph

The pbix is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.