Show different values in chart based on 3 conditions (2 slicer and all) in Stacked Bar Chart

[bsas]

Hello PBI Experts,

I have intersting challenge... how to show different values in Stacked Bar Chart based on values from slicer on values from another field (<> slicer list):

For example: I have slicer (field) with list of people and have a field with another list of people (totally different people).

Can I somehow show if slicer is selected = person from slicer if nothing selected list of people from "another" field.

I'd treid to use something like:

slicer4 = SWITCH(
	         TRUE(),
		CALCULATE(DISTINCTCOUNT('Opp-ty'[ss_projectmanageridname]),
                 ALLSELECTED('Opp-ty'[ss_projectmanageridname]))>1,
                 'Opp-ty'[ss_projectmanageridname],'Opp-ty'[Owner])

or

test_slicer3 = IF(ISFILTERED('Opp-ty'[ss_projectmanageridname]) 
                && DISTINCTCOUNT('Opp-ty'[ss_projectmanageridname])=1,
                 'Opp-ty'[ss_projectmanageridname],'Opp-ty'[Owner])

These are calculated columns (measures can't be used in field "Axis" on Stacked Bar Chart. The problem is that these cc show only person from slicer or all persons from "another field". 

Maybe someone faced with such issue?

Simple data fields:

Person1	Person2	money
Mariya	Andriy	10000
Petro	Oleh	20000
Roman	Andriy	150000
Sergii	Andriy	3000
Oksana	Oleh	70000

[v-chuncz-msft]

@bsas,

Instead, you may drag both columns to Axis, and click the second icon "Go to the next level in the hierarchy" in the top left corner of the visualization.

[bsas]

Thanks @v-chuncz-msft but this is not what I need.

[v-chuncz-msft]

@bsas,

Another way is to select Unpivot Columns in Query Editor.

https://community.powerbi.com/t5/Desktop/multiple-variables-graph-filter/td-p/239301

[bsas]

Thanks @v-chuncz-msft will try to use this tomorrow.