Power BI Dashboard-like Reports

If you’re using Power BI on-premises you may have noticed already that there’s no possibility to pin report parts to a dashboard because dashboards are not supported. Dashboards are only available in the Power BI Service.

To get around this limitation I often create dashboard-like reports like this one:

Screenshot

Even though Power BI Desktop supports „snap to gridline“ this feature isn’t flexible enough as it doesn’t allow you to modify the grid size. You may like to vote here for an improvement.

My workaround is a tiny Excel-workbook that calculates the necessary tile widths, heights and coordinaates based on the number of vertical and horizontal tiles and spaces I like to have.

Setup tab:

Excel1

Resut tab:

Excel2

Once all my tiles are in the report I perform steps as follows

  1. mark all tiles and apply width and height
  2. mark row by row to set Y coordinate
  3. mark column by column to set X coordinate

Still a lot overhead but much easier than tweaking around manually.

The worksheet is available here.

 

 

Advertisements

Kommentar verfassen

Trage deine Daten unten ein oder klicke ein Icon um dich einzuloggen:

WordPress.com-Logo

Du kommentierst mit Deinem WordPress.com-Konto. Abmelden /  Ändern )

Google+ Foto

Du kommentierst mit Deinem Google+-Konto. Abmelden /  Ändern )

Twitter-Bild

Du kommentierst mit Deinem Twitter-Konto. Abmelden /  Ändern )

Facebook-Foto

Du kommentierst mit Deinem Facebook-Konto. Abmelden /  Ändern )

Verbinde mit %s