Solved: Re: undefined

Anonymous · ‎05-10-2022

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?

PabloDeheza · ‎05-10-2022

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!

View solution in original post

Anonymous · ‎05-11-2022

Thank you very much @PabloDeheza , it worked as i wanted after a few changes to this method! marked as solution. Have a nice day! 😄

PabloDeheza · ‎05-10-2022

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!