Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Is it possible to dynamically create a table visual based on URL parameters?

I'd like to have a table visual in Power-Bi which is dynamic in nature based on the URL parameters. Like for example, if in the URL I pass the values as "Country" and "State" , a table should be generated with only those two columns.

Need Help
  • v-xicai's avatar
    v-xicai
    6 years ago

    Hi Anonymous ,

     

    Currently, the URL filter parameter can to pre-filter the report , which will only filter data on row values instead of number of columns. For example , the URL like codes below will filter data 'Table1'[Country] = 'USA' , instead of filtering data to remain the only column Country in the whole report.

     

    app.powerbi.com/groups/me/apps/app-id/reports/report-id/ReportSection?filter=Table1/Country eq 'USA'

     

    That is to say it is not supported to implement in Power BI currently. While your demand is a good idea, and you can post your new idea in Idea Forum , add your comments there to improve Power BI and make this feature coming sooner.

     

    Best Regards,

    Amy 

     

    Community Support Team _ Amy

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

2 Replies

  • v-xicai's avatar
    v-xicai
    Community Support
    6 years ago

    Hi Anonymous ,

     

    Currently, the URL filter parameter can to pre-filter the report , which will only filter data on row values instead of number of columns. For example , the URL like codes below will filter data 'Table1'[Country] = 'USA' , instead of filtering data to remain the only column Country in the whole report.

     

    app.powerbi.com/groups/me/apps/app-id/reports/report-id/ReportSection?filter=Table1/Country eq 'USA'

     

    That is to say it is not supported to implement in Power BI currently. While your demand is a good idea, and you can post your new idea in Idea Forum , add your comments there to improve Power BI and make this feature coming sooner.

     

    Best Regards,

    Amy 

     

    Community Support Team _ Amy

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