Did you know you can adjust the page size of your reports in Power BI? Each tab/page of your report can be a unique size specified by you down to the pixel. This comes in handy for creating “widget-like” visuals for embedding or for creating reports for print and optimal display on various screen sizes.
Your options are:
- 16:9 (default)
- Custom (in pixels)
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 modified for days, weeks, months, etc. as long as the time measure is able to be sorted sequentially.
Power BI Report Server (as of the time of this post) doesn’t allow preview features, therefore doesn’t allow custom themes (easily). But with a little work, anyone can easily “install” a custom theme for their report in PBIRS in just a few steps.
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:
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 URL:
I recently set out to create a “live” conference room schedule that could be presented constantly on an auto-refreshed screen outside conference rooms. This would replace printed schedules placed in holders outside the rooms. The following example uses a SharePoint calendar as the conference room calendar and can be refreshed constantly using Power BI’s scheduled refresh in O365 or Report Server.