Forum Discussion
A hyperlink with a Slicer?
Hello,
I just want to ask if it is possible to click on one of the checkbox in slicer and then it will automatically redirect into a pdf attachment? Based on my research, I'd have to put it into a site and insert the link. I can easily do that in a textbox. But I want it to be on a slicer.
I've already created two columns and convert the URL column into a WebURL.
| Status | URL |
| Status 1 | https://1 |
| Status 2 | https://2 |
For this, I have created a slicer for Status column and when I click on Status 1, I want it to be redirected to URL https://1 automatically.
Another thing I want to ask, Can one slicer will be shown only, once they click on another slicer?
for example.
Slicer 1
| Department |
| IT dept. |
| Accounting dept. |
| HR dept. |
When I choose the IT dept. on Slicer 1, Slicer 2 will pop up. And yes the Slicer 2 is the first question above.
Slicer 2
| Status | URL |
| Status 1 | https://1 |
| Status 2 | https://2 |
Sorry to ask these things as I am just new in Power BI and I would really need some help. Thank you so much!
Anonymous , I doubt the first one is possible. The best you can have it is on a table
https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-hyperlinks-in-tables
I tried with hyper link in the slicer. It is the same as a normal slicer.
For the second one, they should filter , if there are from same table
Else you can follow the approach of adding a visual level filter of fact measure not blank.
refer this video https://www.youtube.com/watch?v=cyOquvfhzNM
2 Replies
- amitchandak
Super User
Anonymous , I doubt the first one is possible. The best you can have it is on a table
https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-hyperlinks-in-tables
I tried with hyper link in the slicer. It is the same as a normal slicer.
For the second one, they should filter , if there are from same table
Else you can follow the approach of adding a visual level filter of fact measure not blank.
refer this video https://www.youtube.com/watch?v=cyOquvfhzNM
I believe this is a better solution:
