cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
SLeat Frequent Visitor
Frequent Visitor

Scatter chart - ignore a slicer

I have a simple dashboard that essentially allows users to select a record from a table using a slicer, and which then populates a report based on that single row.  This works fine, but I'd also like to include a scatter plot that shows where the selected record falls within the entire data set, but that's where I'm running into trouble; at the moment, selecting a record from the slicer then removes all others from the scatter chart, as expected, leaving me with a scatter of one!

 

Is there a way to either make my scatter chart ignore the slicer, so it always displays the entire dataset?

 

I've tried using the ALL function in DAX to create a column that ignores any filtering, but I think I'm probably using it wrong as it's not working and I get an error message about supplying a table where a single value is expected.

 

Also, while I'm asking for help, if there is a way to do the above, is there a way that I can set the chart to "call out" or highlight the value selected in the slicer, essentially pointing out where that record falls in the data?

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Scatter chart - ignore a slicer

Hi @SLeat,

You need to edit the interactions between the slicer and the scatter chart.

Check the documentation below:

https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions

Regards,
MFelix


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




3 REPLIES 3
Super User
Super User

Re: Scatter chart - ignore a slicer

Hi @SLeat,

You need to edit the interactions between the slicer and the scatter chart.

Check the documentation below:

https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions

Regards,
MFelix


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




SLeat Frequent Visitor
Frequent Visitor

Re: Scatter chart - ignore a slicer

Thanks; super obvious solution that I just wasn't aware of!

 

I don't suppose there's an option as easy as that to call out a specific dot/point within a chart, depending on a slicer?

Super User
Super User

Re: Scatter chart - ignore a slicer

To do that the best option would be to use a bookmark.

Where you save the selection of the slicer and the chart for each it selection and the link it to a button.

Regards,
MFelix


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!