Quarter as Date in parameters

[Azzurra997]

Hi AIl

In my powerbi report I used the parameters option to filter a bar chart by day, by month and by year. I would like to do the same by quarter, but power bi doesn't recognize Q1 2022 or Q3 2022 as quarter but only as text. Because in the date/time format there is no quarter option. So when I filter the graph by quarter the bars are not displayed in chronological orders. How can I solve it?

Thanks

[ichavarria]

Hi @Azzurra997,

It´s difficult to provide you with detailed steps without more information. However, to solve this issue, you can create a calculated column in your date table that will extract the quarter from the date. You can then use this calculated column as a filter in your visualizations.

Here are the steps to create a calculated column:

1. Go to the date table in Power BI and select "New Column" from the "Modeling" tab.

2. In the formula bar, enter the following formula to extract the quarter from the date:

   Quarter = "Q" & CEILING(MONTH([Date])/3) & " " & YEAR([Date])

   This formula will create a new column with the quarter and year information in the format of "Q1 2022", "Q2 2022", etc.

3. Click "Enter" to create the calculated column.

4. Now, you can use this new column as a filter in your visualizations. In the "Visualizations" pane, select your bar chart and drag the "Quarter" column to the "Filters" section.

5. Select the quarters you want to display in your bar chart and click "OK".

With this new calculated column, your bar chart should display the bars in chronological order based on the quarters.

Best regards, 

Isaac Chavarria

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

[Bali2022]

Just one thing to add to your formula.  There needs to be a 1 before the close of the CEILING function to designate the "significance" and round the calculated value to the nearest integer:

Quarter = "Q" & CEILING(MONTH([Date])/3, 1) & " " & YEAR([Date])