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)