Mapbox heatmaps

Hi

“Currently I'm using Excel Power Maps to produce heatmap videos and then either embed the videos into Power BI dashboards”, how are the heatmap videos embed, are they added to Power BI dashboard as a video like this or imported with the excel data using Get Data> excel?

It is not possible to obtain a visual the same as your example, there is a workaround to get a similar one.

You can create a Mapbox visual with your dataset in power bi desktop and then add a slicer to filter the visual.

Per your requirement of the data point format, in Mapbox visual, you can select Cluster instead of Heatmap, then change the Max Color and Min Color to what you want.

What do you want to filter by the slicer?

For example , if you want to filter the Latitude and Longitude by the slicer

1.Before you need to define the day by creating calculated columns

day = WEEKDAY([Date sent to company],1)

day of week = IF([day]>1&&[day]<7,"Weekday","Weekend")

2.Then create measures for the one you want to change by selecting in the slicer, eg. Latitude and Longitude

Measure1 =
CALCULATE (
    MAX ( [Latitude] ),
    ALLSELECTED ( Complaints[Date sent to company] )
)

Measure2 =
CALCULATE (
    MAX ( [Longitude] ),
    ALLSELECTED ( Complaints[Date sent to company] )
)

3.Finally, add columns to slicers, for my example, these are columns ’date sent to company’ and ‘day of week’.

Best Regards

Maggie