Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Tvarberg
Helper I
Helper I

Multiple slicers for 1 graph

Hello,

 

I have 3 slicers where interactions have been edited, Meaning selecting from one slicer doesn't affect the others.

The slicers have a bar chart connected.

If nothing is selected in the slicers the bar chart shows everything. 

If one item is selected in one slicer the bar chart shows the item.

However, if selections are made from multiple slicers the graph shows nothing.

 

Is there a way to overcome this?

I'm not able to attach any pbix file for some reason.

Screenshot 1.pngScreenshot 2.png

1 ACCEPTED SOLUTION
_AAndrade
Super User
Super User

When nothing is selecting the behavior is like all items are selected, this is why you're getting all values on the chart.





Did I answer your question? Mark my post as a solution! Kudos are welcome.

Proud to be a Super User!




View solution in original post

3 REPLIES 3
_AAndrade
Super User
Super User

When nothing is selecting the behavior is like all items are selected, this is why you're getting all values on the chart.





Did I answer your question? Mark my post as a solution! Kudos are welcome.

Proud to be a Super User!




_AAndrade
Super User
Super User

Hi,

 

The intersection of slicer 1 and slicer 3 probably doesn't return anything, which is why the graph doesn't show anything. This is my assumption without any other information.





Did I answer your question? Mark my post as a solution! Kudos are welcome.

Proud to be a Super User!




Hi,

thanks for your reply. I agree. But I'm having a hard time understanding why data are returned when nothing is selected. 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.