Select all in the slicer

[viswaaa]

Hi All,

I have a Power BI report where I’m using a country slicer and a table (text chart) that displays Country, Sales, and a URL for each country site.

My requirement is:

1. The text chart should be hidden by default until the user selects a country in the slicer.

2. When no country is selected, a message (e.g., “Please select a country to proceed”) should appear.

3. The slicer should also have a “Select All” option so that users can view data for all countries when needed.

   I used the following DAX to control the chart’s visibility:

    

   ShowChart = IF ( COUNTROWS ( ALLSELECTED ( Sheet1[Business Area] ) ) < COUNTROWS ( ALL ( Sheet1[Business Area] ) ), 1, 0 )

   However, the text chart hides even when the user clicks “Select All.”

   To hide the visual borders/headers, I overlaid a card visual with a transparent background using this measure:

    

   Make Transparent = IF ( ISFILTERED ( Sheet1[Country] ), "#FFFFFF00", // Transparent "White" )

   This works, but since the card visual is on top of the table, users can’t click the country URLs in the text chart.

   ---

   What I need:
   Show a “Select All” option in the slicer.
    By default, hide the text chart and display the message “Please select a country to proceed.”
    When “Select All” is selected, show the text chart with all data

   Any suggestions on the correct DAX or a better approach to achieve this would be appreciated.

[v-pnaroju-msft · Accepted solution]

Thankyou, @amitchandak, for your response.

Hi viswaaa,

We appreciate your query on the Microsoft Fabric Community Forum.

Based on my understanding of the issue, please find attached screenshots and a sample PBIX file that may assist in resolving the matter:
1.When no country is selected.

2.When India is selected.

3.When "All countries" is selected.

We hope the information provided helps to resolve the issue. Should you have any further queries, please feel free to contact the Microsoft Fabric community.

Thank you.

[amitchandak]

@viswaaa , Refer to this blog from exceleratorbi can help

https://exceleratorbi.com.au/show-or-hide-a-power-bi-visual-based-on-selection/