You may create a report you wish to share outside of your organization on the Internet. Today, I’ll take a look at the steps to publish your report to the Internet so that the report has all of the same interactivity as the report you created with Power BI Desktop and published within your organization on the Power BI Service.

edit: This article was written on February 29, 2020. All elements contained within are subject to change with the current monthly release cycle the Power BI team is following.

edit: Make sure you only publish information to the Internet that you have cleared through proper channels within your organization.

Publish From Power BI Desktop To Power BI Service.

You cannot publish directly from Power BI Desktop to the Internet (web). You first must publish from Power BI Desktop to Power BI Service. Go back and check this post if you need a refresher how to publish from Power BI Desktop to Power BI Service.

Open The Report In Power BI Service

Log into the Power BI Service, navigate to your workspace, and open the report you wish to publish to the web. Here, I have a screen shot of the Filled Map Report I have been working with in my last few posts. This shows the population change by state from 2010 to 2019 where a darker color indicates a greater percentage change, while a lighter color indicates a smaller or even negative increase.

File Menu…Publish To Web

In Power BI Service, click on the File Menu. From the File Menu drop-down, click on Publish to web

Create Embed Code

You will receive a dialog window to create an embed code…click the button “Create embed code”

Next, you will receive a warning that you are publishing a report on the Internet that anyone can see. If you are sure you want to proceed, click on the button “Publish”

Generate HTML Code

After you click the Publish Button, you should receive the Dialog Window below indicating that everything was successful and you now have the html code you need to embed the report into a blog or website. You also have a link you can send in an email or paste into a browser to see what the report looks like

Here, I just pasted the link in a browser to see what it looks like:

The Embedded Report

Without further ado, here is the report, embedded in this blog, no more screen shots. This report is live. If I make any changes to the report in Power Bi Service, the change will also be captured here. You may use your mouse scroll wheel to zoom in/out on the map. You can hover on a state with your mouse to see the tooltip for each state. If you do not have this functionality, it is because you have enabled many security extensions on your browser that are blocking the correct functionality of the map. Try another browser such as Microsoft Edge

Admin/Tenant Settings

If you cannot publish your report to the web, it is because your admin for your organization has disabled Publish to web. Ask your admin to enable this feature.

Tidy Up

That’s it for today. Stay tuned for whatever is next….wit? rancor? rant? sarcasm? bramble?…most likely the latter

, , , , ,

Well said by Jim Rohn. Today, I’ll look at at how to format a filled map (Choropleth) in Power BI.

Power BI Desktop Version

I’m using version 2.76.5…. released ~ 12/18/2019. There are no newer updates as of 2/15/2020. If you are using a different version, your results may vary.

Report Window

From the Data Window click on the Report icon on the left. This will stitch the view from the Data Window to the Report Window and expose the Visualization Pane

Create The Filled Map

Click on the Filled Map Visualization Icon in the Visualization Pane. The Filled Map Visualization will appear on the Report Canvas.

Click on the Filled Map on the Report Canvas. This will expose the Location Fields at the bottom of the Visualization Pane. Once the fields are exposed, drag the State Field from the Data Pane to Location. Lastly drag the Pcnt Change Field from the Data Pane to Tooltips in the Data Fieelds at the bottom of the Visualization Pane.

You should now have a filled map that looks something like the image below.

Conditional Formatting

Now I need to add divergent colors to the filled map so I can quickly see which states have the greatest percentage change in population from 2010 to 2019.

  1. Click on the Filled Map on the Report Canvas
  2. Click on the Format Button Below the Icons in the Visualization Pane
  3. Click on the drop-down for Data colors
  4. When you mouse over Default Color notice that a vertical elipses is visible
  5. Click on the vertical elipses
  6. Click on the fx Conditional Formatting pop-up

The Default Color – Data color dialog opens. The State is the default field for Based On Field – click on the drop-down and change to Pcnt Change.

Change the Colors for Minimum and Maximum to 2 different contrasting colors. I’ll use a very light grey and black.

Interpret the Visualization

Even at this small zoom level, it is easy to see some differences in population increases and decreases. It appears as though West Virginia, Illinois and Mississippi had negative to very low population increase. On the other hand; Nevada, Texas and Utah had large population increases.

The only one I found surprising was Utah at 16% increase from 2010 to 2019. I had heard of all of the others through social media and or news outlets over the past few years.

Divergent Color

You can add a 3rd color to the Conditional Formatting if you so choose. Tick the checkbox for Diverging and you will receive a middle value input for the middle color as well.

Custom Color – HEX Only, No RGB

I come from Excel where I am used to using RGB (Red, Green, Blue) values for creating custom colors. RGB is not an option in the Default Color Dialog – you have to use hexadecimal values.

Hexadecimal Resources

I found a good resource for working with hexadecimal colors at color-hex. Make sure you check it out.

Tidy up

That’s it for today. Grab the workbook from my OneDrive. Post inspired by this post at PowerBI tips by Mark Carlo and Seth Bauer.

, , , , , , , ,