cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
shaunguyver
Helper III
Helper III

Scatter chart to show selected record against non-selected records

I have a data table with the following fields:

 

  • Building name
  • Region
  • Square feet (whole number)
  • Cost (£)

In my report I have the following filters:

 

  • Region
  • Building name

 

I have successfully included a scatter chart to show Square Feet v Cost. When no filters are selected, it displays all of the records (buildings) in my data table perfectly.

 

However, once a building is selected in the 'Building name' filter, I want the scatter chart to highlight the selected building (in blue, for example), while the rest of the buildings remain on the scatter chart as grey. 

 

Any help would be greatly appreciated!

2 REPLIES 2
v-yulgu-msft
Microsoft
Microsoft

Hi @shaunguyver,

 

It is not possible to conditionally highlight the chart items which are selected from slicer. Slicer works to filter out unselected records, while keep the selected values remain.

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Would be fantastic if this feature is added to the bubble chart, I need to do the same with my reports.

 

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!