How to use 2 slicers on single chart impacting different axis

[Anonymous]

Hi,
The objective is to show  overall min, avg & max value for comparison with the value for 1 customer.
But the need is to use 1 slicer to decide which all customers to be considered for overall min,avg & max value and 1 slicer for the specific customer with which comparison needs to be done.
Also, the requirement is to view this in a single chart in PBI.
Adding a SS of what I am able to create.
Need to know how I can use 2 slicers on a same chart but for different columns.

P.S. there is no specific need to use any kind of chart, anything which shows the 

[johnt75]

You could create 2 new copies of your customer table, one for each slicer. Make sure that there is no relationship between the copies and any other tables. Depending on which columns you need available in the slicers you could either copy everything or just one or two columns.

Then for the measure to give the min, max etc overall you could do something like

Avg Overall =
CALCULATE (
    AVERAGE ( 'Table'[Value] ),
    TREATAS ( VALUES ( 'Slicer 1'[Group] ), 'Customer'[Group] )
)

and for the individual user

Avg Overall =
CALCULATE (
    AVERAGE ( 'Table'[Value] ),
    TREATAS ( VALUES ( 'Slicer 1'[Group] ), 'Customer'[Group] )
)

[LQuedas]

Hi @Anonymous ,

this is a context & Model problem you need to solve, if you need to have two slicers with customers, one to filter the context of the overall metrics and another one to filter the context of the measures you want to compare with the overall metrics, the easiest way, that is my suggestion, is to change your model dupplicating the Customer table and the Fact table where you have the measures.

hope this helps, LQ