Forum Discussion
SELECTEDVALUE to another sheet
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
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
5 Replies
- fjjpeeters1976Helper III
Thanks, syncing slicers worked
- Ritaf1983Super User
Glad to help 🙂
- Ritaf1983Super User
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
- JayKapuriyaNew Member
If I can not syn slicer then what is the option?
- Ritaf1983Super User
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