MSBI Tutor

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

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