Change Year Into Quarter

[Neetu_2502]

Hi all, I am very new to Power BI. I need to Convert Year into Quarter to show it as a slicer and use it in Matrix. Please assist.

Instead of Years I need to use Q in the slicer

[Neetu_2502]

Thanks for your response!

I have created Datedimension table. Link helped.

I need to show Quarter and year as one slicer tile now, for instance 2023 q1, 2023 q2 etc.

Also, If I use Year field to Matrix from date dimension need the filed to be sorted in Desc order. Do I need to add another column as "sortorder"? if so how to add that.

How to do that

[Ritaf1983 · Accepted solution]

Hi @Neetu_2502 
I don't know if you took the Dax calendar or PQ, but the logic is the same.
For year quarter you can add a column with :
[Year] & " " & [Quarter] 

To sort this column you can add a column with the logic :

For descending sort at matrix column:

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.

[Ahmedx]

try creating a calendar like this

[Ritaf1983]

Hi @Neetu_2502 
The best practice is to create a Calendar table with all needed columns and work with it.

Please refer to the linked tutorial it also has a needed script.

https://radacad.com/do-you-need-a-date-dimension

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