Forum Discussion
Need to create query string url based on user selection in Filters/Slicers in power bi report
Hi,
Could any help me to create a custom query string url based on user selection in report slicers/filters. For example, if any user select one category from report slicer, the query string url get updated with that particular category else if user select multiple categories (i.e out of 10 categories, user selected only 3 categories) then the query string url get updated only with those selected categories(3). These Query String Urls, I can share with multiple customers to view their particluar related data.
Kindly help and suggest how we can create query based user selection.
Regards,
Manohar
ManoharGorantla , You can create a measure like example
example = "http://Abc.com?category" & concatenatex(Table, Table[Column], " ,")
example =max(Table[URL]) & concatenatex(Table, Table[Column], " ,")
2 Replies
ManoharGorantla , You can create a measure like example
example = "http://Abc.com?category" & concatenatex(Table, Table[Column], " ,")
example =max(Table[URL]) & concatenatex(Table, Table[Column], " ,")
Hi Amit Chanda,
Thank you for your early response.now im able concatenate multiple categories of user selection into single string w.r.t seperator comma(,).
Can you Please help me in creating query string in below format. For example, user selected 3 categories like Sports, News and Movie. I want to create query string as follows.
Url = "http://Abc.com?" & Category contains 'Sports' and Category contains 'News' and Category contains 'Movie' . The text "category contains" should repeat based on user category selection. if user selected 3 categories then text "category contains" should repeat 3 times as show in url format, if user selected only 2 categories then text "category contains" should repeat 2 times in usl as below.
Url = "http://Abc.com?" & Category contains 'Sports' and Category contains 'News' . These text "Category contains" repeat dynamically based on user selection of no. of categories.
Regards,
Manohar
