Whenever working with anything geographical, maps are a cool visualization.  One of the new visualization types in Power BI is the filled map, in which regions may be colored rather than just pinpointed.  For example:

And like regular maps, filled maps may work as filter sources as well as filter targets.  In this next image, the bar chart acts as a filter on the table and the filled map:

And in the following illustration, the filled map acts as a filter on the table and the bar chart:

And now the tip.  If you copy the filled map, you get one to work as a filter on the other and therefore create simultaneous high-level and low-level views of the selected area:

This of course works with a filled map filtering a regular map and vice versa.

You can expand this to another level of geographical detail, as in this image with US counties, in which the state of Tennesse is selected in the top map:

In a future post I will work through this last example step by step.  It uses diverging coloring with custom minimum and maximum population values to color the top map, and ranking in DAX to display the top 10 most populated counties.

Get a sample Power BI Desktop file here.

Please follow and like us:

After using the brand-spanking-new Power BI Desktop for a couple of days, these are my favorite features so far, especially as compared to Power View and PowerPivot:

1. Ease of navigation between data model and visualizations.  No more switching between windows.
2. One-click publishing to powerbi.com.  It couldn’t be easier.
3. The new visualization types and the potential market for third-party visualizations.
4. The many (and growing) list of data sources.
5. More control over chart customization (e.g., colors, titles, etc.).  For many people this was a reason for looking at other products and a let down when compared with Excel charts.
6. Seamless integration between data, data transformations, and data model.  Again, no more switching between windows.
7. The unity of interface between the Power BI Desktop and the report editor in powerbi.com.
8. The placing of measures in the fields list of a table.   I could never get my measures to look right at the bottom of the grid and was always playing with the column widths.  Now measures are first-class citizens.
9. The elimination of the colon for defining measures.  Perhaps a minor detail, but syntax simplification and uniformity is always welcome.
10. The ability to connect to and build reports from tabular models without having to import data.  Another huge reason to not look at other products.
11. The promise of frequent updates and improvements.  This should keep the excitement going.
12. The fact that the community’s input is actively being sought and paid attention to.  It’s great when you submit a smile or a frown and you get a response for more information.

What’s still in Power View and PowerPivot that I soon wish to see in the Power BI Desktop, hopefully in an improved fashion:

1. The play axis for scatter charts.
2. More control over fonts.
3. Hierarchies in the data model.
4. KPIs
5. Column filters in the data view.
6. Default aggregations for fields.
7. Synonyms for Q&A.
8. Themes.

Please follow and like us: