Forum Discussion

acg's avatar
acg
Resolver I
1 year ago
Solved

Scatterplot with 4 custom colours on select?

I am working with a bunch of entities, and conducted a ML project. Some entities emerged as outliers and are cathegorised as flagged, the rest is unflagged.  I have a table with entity number and na...
  • v-hjannapu's avatar
    1 year ago

    Hi acg 
    Thank you  for reaching out to the Microsoft fabric community forum.


    You can solve this by creating a separate table for selecting the entity, so it doesn’t filter the main data. Then use a DAX formula to set colours based on which entity is selected and whether it's flagged or not. This way, all entities will always show in the scatterplot selected one in dark colour, others in light colour. Just use EntityColor in legend, and FlagStatus on X-axis and Score on Y-axis. It will work exactly like you want.
    Instead of using a table, I suggest using a slicer to select the entity. It will help show all entities in the scatterplot with correct highlight and color logic as you expected.

    I tested it with my sample data, and it worked fine. Please find the attached Pbix for your reference and gothrough with this link it may help you regarding issue:
    Solved: Change color of scatter depending on selection fro... - Microsoft Fabric Community
    I hope this helped Feel free to ask any further questions. If this resolved your issue, please mark it as "Accept as Solution" and give us Kudos to assist others.

    Regards,
    Harshitha.