Microsoft Previews Customizable Tooltips on Power Map for Excel
New data cards will allow users of Microsoft's geographic visualization software to soon tailor their mouse-over tooltips.Tooltips are getting more personalized in Power Map for Excel's February 2015 update. Power Map is a geospatial visualization add-on for Microsoft's Office spreadsheet application that leverages Power BI, the company's cloud-based business intelligence product, to overlay data on 3D maps of geographical regions. In the latest release, expected sometime this month, Microsoft is introducing data cards. As the company's Excel Team explained in an Office Blogs post, the new feature "extends the Power Map tooltip to let you display more contextual information about the data on your map." Data cards allow users to drill down into the underlying data that makes up their column and pie charts. Another key attribute is their adaptability. According to an online support document, "a data card shows information based on default field list selections, but you can customize the data card to show the details you want. You can add or remove data fields, change the way those fields are aggregated or organized, include a title (such as a location name), or rename the field headers." Users don't necessarily have to start from scratch. "You can also pick predefined data fields from a set of layout templates," added the company.
Microsoft also turned its attention to improving the product's heat mapping capabilities. Previously, heat maps only displayed sum data. Moving forward, "you can use heat maps to represent other aggregation types, like average," under the updated Layer Options tab, wrote the Excel team.