Controlling Visibility with both Expression and Toggle

[BenR55]

Hello,

I have a row that I only want to appear if there information in that row. If there is no information in that row, then I do not want it to show up. Additionally, I want to be able to hide the row with a toggle, even if it contains information. Multiple rows are all using the same toggle and may or may not have information in them.

I have it currently set up with both "Show or hide based on an expression" and "Display can be toggled by this report item:". When I use the toggle to hide all the rows, suddenly the empty rows are showing up. Is there a way to prioritize the toggle or somehow pull the toggle status into the expression?

[v-veshwara-msft]

Hi @BenR55 ,

Following up to see if your query has been resolved. If any of the responses helped, please consider marking the relevant reply as the 'Accepted Solution' to assist others with similar questions.

If you're still facing issues, feel free to reach out.

Thank you.

[v-veshwara-msft]

Hi @BenR55 ,

Thank you for engaging with the Microsoft Fabric Community.

Just following up to check if your query has been resolved and whether the response was helpful. If so, please consider marking the helpful replies as Accepted Solution to assist others with similar queries.
If further assistance is needed, please reach out.
Thank you.

[Anonymous · Accepted solution]

Hi,@BenR55 .I am gald to help you.
Have you tried using parameters in SSRS rdl report?
URL:
Solved: MS Power BI report Buiilder - Need to show/hide Ta... - Microsoft Fabric Community
Hide an item (Report Builder) - Microsoft Report Builder & Power BI Report Builder | Microsoft Learn
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.