Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Team,
I have requirement that when i'm selected quarter, bar graph need to show last 5 quarters from selected quarter.
I have sales table and i need to check how many sales are happend in last 5 quarters.
For example,
I have year Slicer and Quarter Slicer, i selected 2023 qtr 1 then i need to show
qtr1-23,
qtr4-22,
qtr3-22,
qtr2-22,
qtr1-22
Regards,
Siva
@johnt75 ,
I have used this dax
Check that the date column in your fact table, which is linked to the date table, is of type date and not datetime. You'll need to check in both Power Query and in Power BI desktop.
Hi Johnt75,
It is working for monthly scenario, when it comes to Quarter it is not working. Could you please help me.
The principle should be the same, you would need to modify the measure or calculation item to take into account quarters rather than months.
User | Count |
---|---|
49 | |
40 | |
18 | |
14 | |
13 |
User | Count |
---|---|
102 | |
55 | |
28 | |
18 | |
13 |