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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
rluongo
Frequent Visitor

Hide visuals based o conditions

Hi, I need a solution for this requirement.

My report page has two sections. The first one is a table where rows can be selected. The second part has several visuals that have values and should be all displayed only when some items are selected in the table.

I want to show the second part of the page only when the "right" rows are selected in the table (i.e. condition satisfied).

I cannot use images to hide/unhide because visuals to be shown are charts and histograms and slicer. If I work with images they should be in the front ("bring to the front") so no interaction with the visuals is allowed.

I cannot use bookmarks because the action behind the button cannot be disabled.

Have you any suggestion / trick to share?

Roberto

1 ACCEPTED SOLUTION
v-jayw-msft
Community Support
Community Support

Hi @rluongo ,

 

Try create a measure like IF(selectedvalue(table[value])=rightvalue,1,blank()) then add the mueasure to visual filter measure =1.

 

Best Regards,

Jay

 

Community Support Team _ Jay Wang

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

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.

View solution in original post

3 REPLIES 3
Syndicate_Admin
Administrator
Administrator

Realize something similar, All values and titles leave them blank, they are not seen with the white background, and place a box with fill condition (Style, Fill, Function, Rule) between the background and the visual, in my case, select an important value and when it is less than cirta condition, it means that a unique value is being selected, The box changes color and the values are displayed.

dantecervantes3_0-1671032428208.png

v-jayw-msft
Community Support
Community Support

Hi @rluongo ,

 

Try create a measure like IF(selectedvalue(table[value])=rightvalue,1,blank()) then add the mueasure to visual filter measure =1.

 

Best Regards,

Jay

 

Community Support Team _ Jay Wang

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

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.
az38
Community Champion
Community Champion

@rluongo 

I do not see any ways to do that


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.