Latest Enterprise DNA Initiatives

Scatter plot with grouped data colours

Hi all,

Attached is some dummy info for reference. I am trying to create 4 scatter plots all with related assets and units. I have set up the scatter plots into quadrants for:
scatter 1: GDP vs Rent (X) and CPI vs Rent (Y)
scatter 2: Diff in OM (X) and Diff in WAULT (Y)
scatter 3: Diff in rent (X) and Diff in yield (Y)
scatter 4: Diff in OM (X) and Diff in WAULT (Y)

I am using the Asset Name for legend ( and have tried an index with Asset and Unit being same number) as well as Unit ID for details.

The requirement is to have all similar units and assets the same colour i.e. Asset A and Unit A being Blue and Asset B and Unit B being green etc.

There are many more line items than in the sample and I am trying unsuccessfully to get this to work without manually changning the data colours of each graph. This is not ideal as when the user changes the slicer these are all out of whack.

BI data example.xlsx (9.9 KB)

@troylongmuir,

This can be handled nicely via a SWITCH-based measure.

CF Like Items =
SWITCH (
    LEFT ( SELECTEDVALUE ( Data[Unit Name] ), 1 ),
    "A", "blue",
    "B", "green",
    "C", "red",
    "black"
)

you can then select conditional formatting of your scatter points based on field value, and then just choose this measure.

I hope this is helpful.

  • Brian

Thanks - how can I still have asset name in the legend and unit ID in details using this method?

When I add anything in the legend it removes the ability to use the conditional formating in the data colours?

Thanks

Hi @troylongmuir. One way I’ve got around legend issues in the past is to duplicate the visual (without the legend), turn on the legend of the duplicate, then squeeze the duplicate until only the legend is visible. Now with the duplicate overlaid on top of the original, you can get two visuals that each show part of what you want for a complete whole.
Hope it helps.
Greg

1 Like

Thanks a lot - will have a go at this

Hi @troylongmuir, did the response provided by @Greg help you solve your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark as solution the answer that solved your query. Thanks!

Hi @troylongmuir, we’ve noticed that no response has been received from you since the 25th of May. We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.

Hi @troylongmuir, due to inactivity, a response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box.

Kindly take time to answer the Enterprise DNA Forum User Experience Survey, we hope you’ll give your insights on how we can further improve the Support forum. Thanks!