Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
114 | |
89 | |
87 | |
35 | |
35 |
User | Count |
---|---|
152 | |
99 | |
82 | |
63 | |
54 |