When initially PB desktop open all Visualization hide ,once any slicer applied then it should show

[Anonymous]

Hi Team,

Need your support.

When initially PB desktop open all Visualization should be hide( that means look like blank page)  ,once any slicer applied ( example date, classification, priority, states)  then it should show some visualization based on selection.

Please check and do the needful.

[dk_dk · Accepted solution]

Hi @Anonymous 

I have a partial solution that may or may not work for your use case:

Here is the sample page I am using, a simple table with some columns, some of which are used in slicers:

I create a measure:

ShowData = IF(ISFILTERED('Table'),"#FFFFFF00","#FFFFFF")

 If you have a colored background in your report, use the hex color code of your background instead of "#FFFFFF".

If you have visuals built on multiple tables on the page, you need to expand the IF statement to include an ISFILTERED condition for each of the tables:

ShowData = IF(ISFILTERED('Table1')||ISFILTERED('Table2')||ISFILTERED('Table3'),"#FFFFFF00","#FFFFFF")

Then you can place a rectangle shape and make it cover all of your visuals (except for the slicers that you need to interact with.

In the shape settings go to Style -> Fill, and click the fx icon. Set it up like this:

Click ok. Now when you have any filters applied to the Table, the rectangle will become transparent, revealing the  visuals underneath.

This also works with filters in the filter pane, so you do not need to have slicers visible on the page if you do not want to.

The limitation of this method is that the transparent rectangle is "blocking" the visuals on the page, so you will not be able to interact with them.

I hope this helps, let me know if you have any questions!

[Anonymous]

Nice, its working