Forum Discussion

ManoharGorantla's avatar
ManoharGorantla
Microsoft Employee
4 years ago
Solved

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 ...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    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], " ,")

     

ManoharGorantla's avatar
ManoharGorantla
Microsoft Employee
4 years ago

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