how to unselect all values in slicer and display blank in charts

[Joel_sony]

Hey guys!
I have a slicer and chart which respond to the slicer selections. The slicer has a 'Select All' option. When I click 'Select All' the first time, it selects all values in the slicer, and the charts correctly show data for all values. However, if I click 'Select All' again to unselect everything, the slicer deselects all values, but the charts still display data as if all values were selected.

I need the charts to show null or empty visuals when everything is unselected. Is there a way to set up the slicer or a measure so that the charts will display as empty when 'Select All' is clicked twice to unselect everything? I need to preserve the select all option as well.
Does anyone know how to solve this issue? 

PS: Don't mind the clustered bar chart's Y-axis names(edited)

[Anonymous]

Hi,

Based on the description, the method tharunkumarRTK  provided should be helpful.

Please view the method, if the method helps, please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Wisdom Wu

[tharunkumarRTK · Accepted solution]

@Joel_sony 

In Power BI, no selection on the slicer will be considered as "select All", However I have a workaround. You can use disconnected table and achieve your desired output.

When there is no selection on Country:

A country is selected: 

When "Select All" is selected:

You also need to tweak your measure to achive this, I am attaching the PBIX for your reference.

You might have observed the limitation with this appraoch, when I clicked on "Select All" other countries still show as unselected but the output is same is "Select All". This is the only limitation.

Need a Power BI Consultation? Hire me on Upwork

Connect on LinkedIn

Did I answer your question? Mark my post as a solution!
If I helped you, click on the Thumbs Up to give Kudos. Proud to be a Super User!

 

[DataNinja777]

Hi @Joel_sony ,

In Power BI, the slicer has an eraser icon (the "Clear Filter" button) at the top right corner. Clicking this icon will clear all selections in the slicer, effectively deselecting everything and returning the visual to an unfiltered state. This is handy for quickly resetting slicer selections without manually unchecking each option.

Best regards,