Forum Discussion

Nsh's avatar
Nsh
New Member
4 years ago
Solved

How to create a dynamic table value based on selection

Hello everyone,

I have to create report for several schools. Each report has several pages. I now want to create a front page where the schools can select their school and then the report should show the data for that particular school. 

I have created a table (Selected School Table) with a single value (school id) and all the measures in the report are based on that. How can I get this value updated from the front page? 

Thanks a lot. 

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi  Nsh ,

     

    I'm not sure if this can meet your needs. You can create a parameter to achieve your needs, as the following shows:

     

    you just need to instert school id, then it will show related data.

    Detailed steps:

    1.create new parameter

    2.configure parameter

    3. create relationship between parameter and tables

    4. apply this parameter and you can filter school through insert school id.

     

    Best regards,

    Community Support Team Selina zhu

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

     

3 Replies

  • selimovd's avatar
    selimovd
    Most Valuable Professional
    4 years ago

    Hey Nsh ,

     

    use a bookmark for each school that is setting the slicer for the school.

    This slicer can then be synced across all pages with the sync slicer feature:

    https://docs.microsoft.com/en-us/power-bi/developer/visuals/enable-sync-slicers

     

    You can then even hide the slicer and when you click the bookmark the slicer will be used and synced across all pages.

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

    Best regards
    Denis

    Blog: WhatTheFact.bi
    Follow me: twitter.com/DenSelimovic

    • Nsh's avatar
      Nsh
      New Member
      4 years ago

      Thanks. But I need to change the value in the table. Since a lot of measures use the table for calculations. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi  Nsh ,

     

    I'm not sure if this can meet your needs. You can create a parameter to achieve your needs, as the following shows:

     

    you just need to instert school id, then it will show related data.

    Detailed steps:

    1.create new parameter

    2.configure parameter

    3. create relationship between parameter and tables

    4. apply this parameter and you can filter school through insert school id.

     

    Best regards,

    Community Support Team Selina zhu

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