Paginated report - toggle an item on expression

[Markzolotoy]

I know I can toggle an item based on another item. can the toggle be based on an expression? I need to find a way of toggling an item without user interaction.

Thanks

[alwweb2]

You can show and hide based on an expression.  I've used it to add a parameter that can be set to show or hide, and then basically toggle by writing an IIF that shows or hides based on the state of the expression.  I've also thought about, but haven't implemented yet setting the Hide value to False(Expanded and Visible) when the IsInteractive Built-in field is False, and set to True (Hidden) when IsInteractive is true so that all of the levels are displayed in the pdf exports, but you have to manually drill-down when the report is displayed in the service. 

[Markzolotoy]

@v-rongtiep-msft Not sure how it is all related to my question.

[v-rongtiep-msft]

Hi @Markzolotoy ,

I have found a similar post , please refer to it to see if it helps you.

Solved: Paginated Reports - Expression debugging method - Microsoft Power BI Community

• Refer to the related solution below.

  Solved: Re: Developing Paginated reports from Visual Studi... - Microsoft Power BI Community

How to Add a Toggle Feature to Your Power BI Repor... - Microsoft Power BI Community

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.