Forum Discussion
PowerBI Report With Map
Hi folks
I have requirement to show map on PowerBi report with help of lat & lang but another requirement is once user drill down to a specific record/location, I have to show him a hyperlink from which will be in attached dataset and user clicks on the hyperlink to view the document associated with that particular record/location.
This possible to achieve in PowerBI.
Thanks
Hi, noorahmad
In my sample,I use name(in map) as the target of 'drill through', then drill through to the corresponding url. You can check my sample gif ,there is a clear process on it.
Drill through:Set up drill through in Power BI reports - Power BI | Microsoft Docs
If it doesn’t solve your problem, please feel free to ask me.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
7 Replies
Hi noorahmad
Yes this is possible.
What you will have to do is to build the Hyperlink as part of your data import process in Power Query. This will be a new column where you will build the hyperlink URL.
Then once you add the hyperlink to a table you can then give it the data category of Web URL.Here are more details on how to complete this: Add hyperlinks (URLs) to a table or matrix - Power BI | Microsoft Docs
I want this on the map not in the table, allowing user to click on a location and download the document.
Hi, noorahmad
According to your description, I made a sample to show you how to use web url in map,and it involves the knowledge of 'drill through'.
Like this:
Reference:Set up drill through in Power BI reports - Power BI | Microsoft Docs
Here is my sample .pbix file.Hope it helps.
If it doesn’t solve your problem, please feel free to ask me.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
