Hello,
I have a table with the following columns, among others: [(Price data with varying price), (Size of sold units (varies from 10-200)), (salesgroup)].
I am trying to achieve a report & plot with the following conditions:
* Page is filtered on a certain salegroup chosen from a slicer.
* Scatter plot of all sales, y axis is price and x is size of sold units. here, I want the filtered salesgroups name to be in one color, and at the same time, i want all other sales made by other sales groups also to be visible but in another color. So for example; Sales of group north would be highlithted in orange, and sales of group west,south,.....etc. to be in blue.
How can I achieve this? Have been trying different solutions such as Highlight Key Points In Scatter Charts - Compelling Data Viz Technique In Power BI - YouTube which i thought would work, but seems maybe to work only to highlight one point at a time (I didn't get that method to work at all).
I am aware of how i can make the slicer not remove any data on the specific scatterplot by changning interactions. Also, I know that i can fetch the selectedvalue with SELECTEDVALUE() function, which I have tried to use in various ways but with no success.
Does anyone know a solotuion for this?
Thanks
