The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi All,
I have recently implemented a azure map using a reference layer in the Power BI desktop:
And as you can see the fill colour is set by a function - a colour gradient based on a measure. The map functions as expected in the desktop app.
But when I publish the map I just get this:
and if I look at the "edit" options:
The polygons are set to a constant colour and it is not possible to set them as a function. Also hovering over the visual does not display any tooltips.
If I export the data of the visual the data is as expected.
Why is there this difference between desktop and published?
I unfortunately have the same issue.
I cannot conditionally format the reference layer:
Hi,
This issue looks different to what mine was. I had in working in the desktop version, it was only when publishing it that I lost the measure set colour for the polygons. This option was simply not available on the online version either. This issue fixed itself without input from myself.
For your issue I would look into the tooltips and check for cohesion between the data set and the geojson file for whatever you are using to link them (region name, code, etc.)
I also found, when trouble shooting, that ensuring unmapped objects were not shown and that the colour in my measure was different from the default blue. It makes it easier to locate the issue.
Hi @LeverPowerCLiff ,
Regarding your problem, check if there is any defined style in your GeoJson file.
If your geospatial files (GeoJSON, KML) include predefined style properties, Power BI will utilize those styles rather than the settings configured in the format pane. Make sure your files are styled according to your requirements before uploading if you intend to use custom properties defined within them.
Link that may help
Solved: Re: Need to control the color of a Reference Layer... - Microsoft Fabric Community
Best Regards,
Wenbin Zhou
Thank you for your reply.
I have doubled checked the geojson file, there are no colour settings in there anywhere. I have followed the steps in that first link but the formatting of the azure map reference layer just disappears when it is published and there is no conditional formatting option in the online editor.
The 2nd link you sent only talks about using a 3rd party visual. Is there no way to use the azure map and the reference layer only in Power BI online?