The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi all!
I'm trying to make a report where you can select a week in a slicer, and a graph will display the selected week and the 12 weeks before it.
The thing is, when i connect a slicer to the graph, the graphs only shows the data selected with the slicer.
When i remove the interactions with the slicer, i can't use a measure to work on the graph (my measure uses SELECTEDVALUE, and it can't work if it's not linked to the graph)...
Any workarounds?
Solved! Go to Solution.
Hi @Anonymous !
Please refer to this video from SQLBI explaining how to achieve this with months. It can be later applied on weeks for your requirement: https://www.youtube.com/watch?v=d8Rm7dwM6gc
let me know if that helps!
Thank you very much @PabloDeheza , it worked as i wanted after a few changes to this method! marked as solution. Have a nice day! 😄
Hi @Anonymous !
Please refer to this video from SQLBI explaining how to achieve this with months. It can be later applied on weeks for your requirement: https://www.youtube.com/watch?v=d8Rm7dwM6gc
let me know if that helps!
User | Count |
---|---|
28 | |
12 | |
8 | |
7 | |
5 |
User | Count |
---|---|
34 | |
15 | |
12 | |
7 | |
6 |