4

Normally in BI tools, I open a report page, see empty tables, their column names, and empty charts. I select some filters from header place and click on the View button to query report and see the result.

But in PowerBI, when I open a published report page, I see a completely rendered report. If I want to apply a date range, I have to run report again. In this way, my report query runs twice, but I don't want to spend my CPU power on the initial rendered full report with data.

How can I prepare reports and publish in PowerBI, which End users may see an empty page or empty charts? The report must be displayed with data only if the end-user selects the filters and click on any apply button.

Ozan Dikerler
  • 55
  • 8

1 Answers1

1

Q: How to render report charts after filters are applied in PowerBI?

A: Bookmarks

Yes, even empty reports can easily be done using the feature in Power Bi Desktop. The idea behind a Power Bi's bookmark is that it will remember or preserve your report page visuals in any filtered state.

So, to get the empty report style, set your filters or slicers so that no results are displayed in your report page, then save things as a bookmark. Click Add in the bookmarks pane, and name it to something you will remember.

Then on the main index page for your reports, link to your report using that bookmark to your report with empty results.

Example

Turn on bookmarks by clicking the bookmarks pane checkbox under the view menu:

enter image description here

Note: If you are using a version prior to March 2018, the bookmarks are a preview feature and might not be found in the view menu.

For the following report data:

enter image description here

The below report which displays song data in a table, number of songs in the card on the right and a date slicer below. Note the date range intersects some of the song dates in the data and these are the songs displayed in the reports table and card:

enter image description here

If you then enter in a dates into the slicer (12/31/1970) that do not intersect the dates in the table, this will zero out the report:

enter image description here

Then you go to the bookmarks pane and Click the Add button at the top as Bookmark 1. Right-click and rename to "Blank Song Report".

Now anywhere in your presentation, you can link back to a blank song report using this "Blank Song Report" bookmark. Being able to save reports in a certain state is a powerful feature and you can achieve this through Bookmarks.

re: CPU power

All CPU power spent on Power Bi Reports is on the client side of things. If the reports are run inside of Power Bi Desktop that is in a program on the users computer. If the report is served from Power Bi service or from Power Bi Report Server the users browser will be running and rendering the report via JavaScript. So there is no need to worry about "CPU spend", because it will all be on the client side.

Taterhead
  • 5,763
  • 4
  • 31
  • 40