topic Re: undefined in DAX Commands and Tips

undefined

Anonymous — Tue, 10 May 2022 14:22:24 GMT

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?

Re: undefined

PabloDeheza — Tue, 10 May 2022 14:29:27 GMT

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!

Re: undefined

Anonymous — Wed, 11 May 2022 09:24:57 GMT

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