SELECTEDVALUE to another sheet

[fjjpeeters1976]

Hi all,

I am creating a report with several pages, on the first page is a Welcome (Info) page that should show the reporting month. This should be a static input that is linked to a settings page where the reporting month can be selected. This settings page will be hidden for the end user. So the reporting month on the first page should not be a filter or changeable by the end user. I thought to create this by having a filter on the settingspage and using a SELECTEDVALUE statement on the welcome page. But this does not seem to work. In excel I could just link the cell to the cell of the other sheet, but I do not know if Power BI has a similar function.

thanks,

Frank

[fjjpeeters1976]

Thanks, syncing slicers worked

[Ritaf1983]

Glad to help 🙂

[Ritaf1983 · Accepted solution]

Hi @fjjpeeters1976 
There are no options to use selectedvalue based on another page, but you can sync slicers.
Please refer to the linked tutorial:

https://www.youtube.com/watch?v=03-MZBxmKVM

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[JayKapuriya]

If I can not syn slicer then what is the option?

[Ritaf1983]

Hi @JayKapuriya 
I don't think there are other options...unfortunately.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly