MSBI Tutor

With Shape Map (Generally Available) in Power BI, you can display data on any shape you can define—countries, regions, or other geographical boundaries—and color each area based on your data to quickly spot patterns and compare values.   Whether you’re analyzing sales across geographic territories or comparing performance across franchise locations, Shape Map lets you visualize data on maps that match your actual business boundaries rather than standard administrative regions. Define your own map boundaries using TopoJSON or GeoJSON files. Three ways to add maps Built-in maps Choose from ready-to-use maps for common regions: US states, Canadian provinces, Australian states and territories, German states, French regions, and more. Upload custom maps Upload your own TopoJSON or GeoJSON file for boundaries not available in the built-in options—sales territories, judicial districts, or any other regions specific to your organization. Reference maps via URL Point to a map file hosted on...

Tooltips give consumers context about the data point they're hovering over — the full value, a year-over-year change, a related KPI, a quick explanation — without ever leaving that data point. Power BI offers a flexible set of tooltip options so you can start with the defaults and add as much customization as the report needs.   The options progress from least to most custom: Default visual tooltip — Power BI builds the tooltip from the fields in your visual. Tooltip field well — Add extra fields to enrich the default tooltip. Tooltip fields only and Sentence format only (newly generally available) — Curate the exact field list or write the hover content as a sentence. Report page tooltip — Replace the tooltip entirely with a report page you design. A separate Help tooltip icon in the visual header gives consumers guidance about the visual itself rather than the data point, and it coexists with whichever data tooltip you pick. Default visual tooltips and the Tooltip field wel...

With visual calculations (Generally Available), you can write DAX directly on a visual to calculate exactly what you need to show. They're useful when a calculation is specific to a single visual, so you can define the logic right where you need it instead of adding a model or report measure.   Figure: Create a visual calculation directly on a Power BI visual.   Custom totals for tables and matrices are also generally available. Custom totals are powered by visual calculations and give you a simple way to adjust the total row to fit your reporting needs.   Figure: Customize totals for table and matrix columns using built-in aggregation options. How visual calculations work A visual calculation is a DAX calculation directly on a visual. Because the calculation runs against the aggregated data already on the visual, the DAX is often simpler than the equivalent measure, and you don't need to manage filter context across the whole model.   To add a visual calculation, se...