Posts

Deep dive into Power BI reporting with the new date picker slicer option (Preview)

Image
Report authors often need date filters that automatically keep reports focused on the most relevant data without requiring ongoing maintenance. The new date picker slicer makes this easier by supporting dynamic relative date ranges that move forward as data refreshes, while still allowing report viewers to explore different date ranges, individual dates, and custom periods when needed.   Most reports have a date and report viewers want to see the latest data or pick their own date ranges. The date picker style of the slicer visual gives report authors and report viewers options to do it all.   Set up a relative range, such as last 30 days from the last date available. Anchor it on the last date, first date, or today with offset options to do last 30 days, starting 5 days back, if you want. This relative range automatically moves forward as your data refreshes and more data comes in. Publish the report and it’s the default relative range.   Your report viewers remain free ...

Deep dive into the Shape Map in Power BI (Generally Available)

Image
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...

Deep dive into tooltip options in Power BI visuals (Generally Available)

Image
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...