How to handle report not to auto run

[mery77]

Hi everyone!, I am strugling with a request from the user, may be you can help me on this:

I have 3 slicers in my power bi desktop report, Currently when the report is open is showing data as follow:

But we need that when the report is opened it does not auto-execute, and does not show the values of the detail grid, that is, it only shows the header of the columns and nothing in the detail of the grid (see image as below)

Do you know of any feature in power bi for which the report does not run as soon as it is opened / displayed for the first time?

something like having a default value of null in the slicers so that when the report loads for the first time the detail of the report only shows until the user chooses the values of the slicers?

How to handle report not to auto run, what should be the default values?

any ideas?

Thank you in advance, any assistance is greatly appreciated

[amitchandak · Accepted solution]

@mery77 , Try if these setting can help

Or refer to my video a different approch

Traditional Parameter Page: https://youtu.be/F3qMwQtWjvo

[v-angzheng-msft · Accepted solution]

Hi, @mery77 

As far as I know, we can't make the table default to null every time the report is opened. But we can make the table empty the first time the user opens the report, and since the report saves your slicer state, make sure the slicer is unchecked before sending the report to the user, then the user will see the empty table when they open the report.
We can do this by creating a filtered measure.
First create a calculated table to summarize the slicer field, then use the summarized field to create the slicer without using the field from the main table.
Then we create the measure and filter the measure in the filtering pane. So we can get the visual effect that the slicer is not selected and the table is empty by default.

Sample: financial.xlsx

measure:

__noData =
VAR _show =
    IF ( MAX ( 'financials'[Product] ) IN VALUES ( _Slicer[Product] ), 1, 0 )
VAR _isSelected =
    IF ( ISFILTERED ( _Slicer[Product] ), _show, 0 )
RETURN
    _isSelected

result:

Please refer to the attachment below for details

Hope this helps.

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@mery77 , Try if these setting can help

Or refer to my video a different approch

Traditional Parameter Page: https://youtu.be/F3qMwQtWjvo