Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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
Solved! Go to 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.
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
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.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
85 | |
66 | |
51 | |
45 |
User | Count |
---|---|
216 | |
89 | |
82 | |
66 | |
57 |