How to add rows for dates between start and end dates in Power BI date range data

In Power BI there are several custom visuals available, such as Elastacloud's Calendar Visual, that show the density of events over time. However, if your data includes date ranges (start date with a different end date, such as task/project lists), visuals…

Power BI: Calculate next year’s amount in previous year’s row

The following is a DAX formula you can use to create a calculated column that shows "next year's" value in "this year's" row. You can easily adapt this to show "yesterday's" amount or "tomorrow's" total as well. It can be…

Embedding Power BI Report Server (PBIRS) reports in SharePoint

If you're on-premises and looking to embed a Power BI Report Server report in SharePoint, you'll find it's not as easy as O365 embeds. But it's certainly possible; here's how: Create a full-screen URL for the report you wish to…

How to create a powerful date table or DateKey in Power BI

DateKeys are essential for relative time measures. In "manage relationships" you tie the 'DateKey'[Date] to a date field in each of your data sources. Giles Walker shared an excellent solution for a robust DateKey that includes measurements and calculations you're…

View and share Power BI Report Server (PBIRS) reports full screen

The O365 Power BI Service has an easy "expand" icon on reports to make them full screen whereas Power BI Report Server (PBIRS) lacks that feature. We can still view reports full screen, however, using this simple trick in the…