Forum Discussion

fjjpeeters1976's avatar
fjjpeeters1976
Helper III
3 years ago
Solved

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

5 Replies

      • Ritaf1983's avatar
        Ritaf1983
        Super 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