Forum Discussion
Show table only when slicer options selected
Hello all,
In my page i have two slicers "Date" and "category" and one table. I want to show this table only when a option is selected in both the slicers(both mandatory) and hide table when no option selected. when no option is selected i will have textbox to tell to select some values.
Thankyou
Hi Anonymous ,
For your issue, you can do like this:
First, create a measure and add it in a card visual:
Message = IF( ISFILTERED(Sales[Brand]) && ISFILTERED(Sales[Month]), "", "Please select the two slicers" )Second, create another measure and add it in the background of the card visual:
// "#FFFFFF00" is transparent Make Transparent = IF( ISFILTERED(Sales[Brand]) && ISFILTERED(Sales[Month]), "#FFFFFF00", "White" )Third, let card visual completely cover the matrix visual:
What you can achieve:
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
v-lionel-msftCommunity Support
Hi Anonymous ,
For your issue, you can do like this:
First, create a measure and add it in a card visual:
Message = IF( ISFILTERED(Sales[Brand]) && ISFILTERED(Sales[Month]), "", "Please select the two slicers" )Second, create another measure and add it in the background of the card visual:
// "#FFFFFF00" is transparent Make Transparent = IF( ISFILTERED(Sales[Brand]) && ISFILTERED(Sales[Month]), "#FFFFFF00", "White" )Third, let card visual completely cover the matrix visual:
What you can achieve:
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.