Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Nilo
Frequent Visitor

Python visual displaying a map in a new webpage

Hello All,

 

I am trying to create a heatmap, using the Power BI heat map visual,  it doesnt fulfill my purpose, as i dont see option to add text on hover, and no way to add a tooltip.

I tried creating one using python visual and it wroks perfectly, the only problem is that it shows up in a new web page, instead on the report view.

 

I am not sure, if theres something that i missed in the code, or thats how it works.  Please find teh code below

# The following code to create a dataframe and remove duplicated rows is always executed and acts as a preamble for your script:

# dataset = pandas.DataFrame(shipcountry, postcode)
# dataset = dataset.drop_duplicates()

# Paste or type your script code here:
import pgeocode
import pandas as pd
import plotly.express as px
import numpy as np

fig = px.density_mapbox(dataset, lat='latitude', lon='longitude', z='Adjusted Revenue', radius=10,
                        center=dict(lat=dataset['latitude'].mean(), lon=dataset['longitude'].mean()), zoom=5,
                        mapbox_style="open-street-map")

dataset['Adjusted Revenue'] = dataset['Adjusted Revenue'].round(2)

hover_data = {
    'latitude': False,
    'longitude': False,
    'Adjusted Revenue': True
}

fig.update_traces(customdata=dataset[['Adjusted Revenue']],
                  hovertemplate='<extra></extra>Adjusted Revenue: €%{customdata:.2f}')


fig.show()

I am quite new to Power BI, and would really appreciate your help.

Thanks,
A fellow student tired of googling.
1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

You cannot bring your own renderer ( plotly.express in your case).  You must use the default renderer.

View solution in original post

4 REPLIES 4
lbendlin
Super User
Super User

You cannot bring your own renderer ( plotly.express in your case).  You must use the default renderer.

Nilo
Frequent Visitor

Okay, thanks.

And if I use the default Map visual, I am unable to add hover over the map funcionality, is there anyway I could do that?

Didn't Arcgis have heatmap options? You can also consider using Deneb.

Nilo
Frequent Visitor

oh wow, yes! I activated the ArcGIS settings and I was able to get what I was looking for, thank you!

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.