Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Peter_23
Post Patron
Post Patron

Show/hide visual object or tab report dynamics

hi there, I would like to show/hide visual objects in  dynamic report, so I have a flag (1,0) so if this flag it set to 1 then show "table visual" hide ("matriz visual")  else if flags set to 0  show "matrix visual" (hide "table visual)"

 

Another approched is: It have 2 tabs reports (one table visual and other matrix visual) based in condition (flag) show/hide tab....

 

Is there any workaround to make this possible?

 

PD. I don't like use boorkmarks

 

thanks in advance.

 

1 ACCEPTED SOLUTION
Kedar_Pande
Super User
Super User

@Peter_23 

Use Two Report Tabs (Pages) and Conditional Navigation

  • On Page 1, place the Table Visual 
  • On Page 2, place the Matrix Visual

Place two buttons on the main page, one that links to Page 1 and one to Page 2.
Use the Format pane > Action settings to set each button to Navigate to the correct page.

 

💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn

 

View solution in original post

6 REPLIES 6
Peter_23
Post Patron
Post Patron

I hope in the next years this feature it's available.

Kedar_Pande
Super User
Super User

@Peter_23 

Use Two Report Tabs (Pages) and Conditional Navigation

  • On Page 1, place the Table Visual 
  • On Page 2, place the Matrix Visual

Place two buttons on the main page, one that links to Page 1 and one to Page 2.
Use the Format pane > Action settings to set each button to Navigate to the correct page.

 

💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn

 

Thanks @Kedar_Pande with the two buttons is this possible hide/show?

Anonymous
Not applicable

Hi @Peter_23 , hello Kedar_Pande, thank you for your prompt reply!

 

There is no property that directly control the visibility of buttons.

 

As a workaround, you can create a measure that controls the button style colour to a transparent #FFFFFF00 to indirectly hide it.

Make Transparent = 
      IF(
         SELECTEDVALUE('Table'[flag])=0,
         "#FFFFFF00", -- returns transparent if condition is True
         "black"
      )

vyajiewanmsft_1-1730442873512.png

Best regards,

Joyce

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

thanks @Anonymous  this property is avaliable in table visual?

 

 

Anonymous
Not applicable

Hi @Peter_23 , 

Thank you for your feedback.

 

As far as I know, table visual don't have this conditional formatting.

vyajiewanmsft_0-1730688673975.png

Best regards,

Joyce

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

 



Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors