Forum Discussion
Multi variable scatter plot
- Anonymous5 years ago
Hi lushd ,
Please try the following steps:
1. Createa a new table with Legend type (Port and Company) for slicer.
2. For dynamic Y-axis:
Measure = SWITCH(MAX('ForSlicer'[Legend]), "Port",CALCULATE(MAX('Table'[discharge time]),FILTER('Table','Table'[Port]=MAX('Table'[Port]))) , "Company", CALCULATE(MAX('Table'[discharge time]),FILTER('Table','Table'[Company]=MAX('Table'[Company]))))3. Create a rank measure for conditional formatting:
For conitional formatting = SWITCH(MAX('ForSlicer'[Legend]), "Port",RANKX(ALL('Table'), CALCULATE ( MAX ( ( 'Table'[Port]) ) ),,ASC,Dense) , "Company", RANKX(ALL('Table'), CALCULATE ( MAX ( ( 'Table'[Company]) ) ),,ASC,Dense))4. Add Port and Company to tooltips field.
Or unpivot the table.
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi lushd ,
Please try the following steps:
1. Createa a new table with Legend type (Port and Company) for slicer.
2. For dynamic Y-axis:
Measure =
SWITCH(MAX('ForSlicer'[Legend]),
"Port",CALCULATE(MAX('Table'[discharge time]),FILTER('Table','Table'[Port]=MAX('Table'[Port]))) ,
"Company", CALCULATE(MAX('Table'[discharge time]),FILTER('Table','Table'[Company]=MAX('Table'[Company]))))
3. Create a rank measure for conditional formatting:
For conitional formatting =
SWITCH(MAX('ForSlicer'[Legend]),
"Port",RANKX(ALL('Table'), CALCULATE ( MAX ( ( 'Table'[Port]) ) ),,ASC,Dense) ,
"Company", RANKX(ALL('Table'), CALCULATE ( MAX ( ( 'Table'[Company]) ) ),,ASC,Dense))
4. Add Port and Company to tooltips field.
Or unpivot the table.
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.