Forum Discussion
Change Year Into Quarter
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
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.
4 Replies
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.
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
try creating a calendar like this
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.
