Forum Discussion
undefined
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?
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=d8Rm7dwM6gclet me know if that helps!
2 Replies
- PabloDeheza
Solution Sage
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=d8Rm7dwM6gclet 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! 😄