Forum Discussion
Solved
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.
I am quite new to Power BI, and would really appreciate your help.
Thanks,
A fellow student tired of googling.
You cannot bring your own renderer ( plotly.express in your case). You must use the default renderer.
4 Replies
You cannot bring your own renderer ( plotly.express in your case). You must use the default renderer.
