when unselect all values showing still all values

[lucie_raboch]

Hello,

I have a slicer and line chart, when I unselect all values from slicer I expecting that the line will be blank, but it is still showing all values, see print screen. 

Can I somehow make the line be invisible when I unselect all values?

Thank you

[Anonymous · Accepted solution]

Hi @lucie_raboch ,

Thanks to @ExcelMonke  for the reply, please allow me to provide another insight:

When all values are deselected in a slicer, the slicer does not filter any values, that is, all values are displayed. Therefore, selecting nothing and selecting all are the same logic.

1. Modify measure.

Measure =
VAR _sum = SUM(financials[Sales])
RETURN
IF(NOT ISFILTERED('financials'[Country]),0,_sum)

2. Hold down the CTRL key to manually select all values in the slicer to create a bookmark.

3. Create a button that can select all.

    

4. The result of not selecting any value and holding down the CTRL key when clicking the button is as shown below. More details can be found in the pbix attachment.

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

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

[lucie_raboch]

This is working, just change 0 --> blank and line is blank 🙂 Thank you so much

[lucie_raboch]

This is the measure, as you can see everything has been unselect and it is still showing line with total

Basically there is no difference between Select ALL and Unselect ALL in this slicer. Or?

[ExcelMonke]

There may be two things going on here:

1. your filter is not interacting with the graph. When you click the slicer, go to Format (top bar), and select interactions. Make sure that it is toggled to interact with the chart
2. your measure to calculate the Y-Axis value may contain an ALL() clause (or other filter clauses), which will ignore the page slicer.

[lucie_raboch]

Hi, thank you for your answer. My filter has interaction with the table and I have very simple measure contains SUM function, there are no filters, it looks to me like standard behaviour of slicers in Powerbi but why? How can I avoid this.

[ExcelMonke]

In order to best understand, I would have to see the measure