Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to 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.
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.
This is working, just change 0 --> blank and line is blank 🙂 Thank you so much
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?
There may be two things going on here:
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.
In order to best understand, I would have to see the measure
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
83 | |
64 | |
60 | |
55 |
User | Count |
---|---|
179 | |
108 | |
105 | |
71 | |
70 |