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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Mokegubshook
Helper I
Helper I

Hide and show visual base on slicer

Hi, I want to hide visual base on my slicer which made from Field Parameter.

If I select completeness Status then I want to hide or show some visual.

Mokegubshook_0-1745845004385.png

My slicer is made from field parameter

Mokegubshook_1-1745845091192.png

 

My problem is, I try many way but got errors like "Parameter is part of composite key"

 

1 ACCEPTED SOLUTION
bhanu_gautam
Super User
Super User

@Mokegubshook 

Create a DAX Measure for Visibility: You need to create a DAX measure that determines whether a visual should be shown or hidden based on the slicer selection. For example:

ShowVisual =
IF(
SELECTEDVALUE('Parameter Table'[Parameter Fields]) = "Completeness Status",
1,
0
)
This measure returns 1 if "Completeness Status" is selected, otherwise 0.

 

Use the measure to conditionally format the visual's transparency or visibility. You can do this by:

Selecting the visual you want to hide/show.
Going to the "Format" pane.
Finding the property that controls visibility (like "Transparency" or "Visibility").
Applying a rule based on the ShowVisual measure. For example, set transparency to 100% when ShowVisual is 0 and to 0% when ShowVisual is 1.

 

Alternatively, you can use bookmarks and the selection pane to control the visibility of visuals. Create bookmarks for different states (e.g., one with the visual shown and one with it hidden) and use the slicer to trigger these bookmarks.




Did I answer your question? Mark my post as a solution! And Kudos are appreciated

Proud to be a Super User!




LinkedIn






View solution in original post

4 REPLIES 4
v-echaithra
Community Support
Community Support

Hi @Mokegubshook ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

 

Regards,
Chaithra.

v-echaithra
Community Support
Community Support

Hi @Mokegubshook ,

We wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

 

Regards,
Chaithra.

v-echaithra
Community Support
Community Support

Hi @Mokegubshook ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

 

Regards,
Chaithra.

bhanu_gautam
Super User
Super User

@Mokegubshook 

Create a DAX Measure for Visibility: You need to create a DAX measure that determines whether a visual should be shown or hidden based on the slicer selection. For example:

ShowVisual =
IF(
SELECTEDVALUE('Parameter Table'[Parameter Fields]) = "Completeness Status",
1,
0
)
This measure returns 1 if "Completeness Status" is selected, otherwise 0.

 

Use the measure to conditionally format the visual's transparency or visibility. You can do this by:

Selecting the visual you want to hide/show.
Going to the "Format" pane.
Finding the property that controls visibility (like "Transparency" or "Visibility").
Applying a rule based on the ShowVisual measure. For example, set transparency to 100% when ShowVisual is 0 and to 0% when ShowVisual is 1.

 

Alternatively, you can use bookmarks and the selection pane to control the visibility of visuals. Create bookmarks for different states (e.g., one with the visual shown and one with it hidden) and use the slicer to trigger these bookmarks.




Did I answer your question? Mark my post as a solution! And Kudos are appreciated

Proud to be a Super User!




LinkedIn






Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

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.