Forum Discussion
Kedar_Pande
1 year agoSuper User
Dynamically Highlight Data Points on Scatter Plot
I have a scatter plot in Power BI displaying product performance across different metrics. The X-axis represents "Sales Growth" and the Y-axis represents "Profit Margin." I also have a slicer for "Product Category" that allows users to select different product categories.
Requirements:
- When a specific "Product Category" is selected in the slicer, I want all points belonging to that category to be highlighted in a distinct color.
- The non-selected categories should remain visible but appear in a faded/gray-out color.
| Product | Category | Sales Growth | Profit Margin | Units Sold |
| A | Electronics | 10% | 20% | 5000 |
| B | Apparel | 5% | 25% | 3000 |
Thanks
1 Reply
- tharunkumarRTKSuper User
You can acheive it by creating a disconnected table for Product category. I would suggest you to watch this SQL BI
https://www.youtube.com/watch?v=ZR7kubCj-YwHere is a sample file:
Need a Power BI Consultation? Hire me on Upwork
Connect on LinkedIn
Did I answer your question? Mark my post as a solution! If I helped you, click on the Thumbs Up to give Kudos.
Proud to be a Super User!