Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I hope i can explain this correctly for you all and any help is greatly appreciated.
please see below the dashboard i have. it is sliced on week number which is in its own dates table using the calendar auto command.
I want to show the bottom left visual for week 6, 7, 8 and 9 as you can see its only showing week 9 at the moment as the week number slicer is set to week 9 top right.
so based on the week number slicer at the top right can it show the last 4 weeks just in that visual. I also know about the edit interactions to stop it taking on that specific slicer.
Thanks,
Adam
Solved! Go to Solution.
Hi @Anonymous ,
if you have a date, the relative filtering provided by Power BI could do the trick without entering in too much DAX:
Apply this to your visual and check if it is exactly what you want.
Best Regards,
ID
Hi @Anonymous ,
if you have a date, the relative filtering provided by Power BI could do the trick without entering in too much DAX:
Apply this to your visual and check if it is exactly what you want.
Best Regards,
ID
thanks a lot i think that has solved it! will that just pull today date every time then and show the last 4 weeks?
Yes, if you select include today, it will give you the las 4 weeks strating today.
Just make sure to check the diference in terms or result from Calendar week and Week and see which one suits you the most.
@Anonymous , you will need an additional independent date table for that.
refer this case with date table and 12 month
https://www.youtube.com/watch?v=duMSovyosXE
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |