Slicer to change source column based on other slicer

[Anonymous]

Hello, I hope the request below is clear enough...

 I have a table that looks like the below. I would like to be able to do the following in order to make a presentation to my customers, i.e. the operators A, B, C, D mentioned in the table. I will have to meet the customers separately.

- My customers are interested is seeing a bar chart with their values (Failure Index) against time, but also against a "similarly sized" operator which would have to be anonymised. So I need the bar chart to show 2 series of columns: for example when presenting to "Operator A", one bar should be called "Operator A" and one should be called "Similar Operator" in the legend.

- Say that for example Operator B is a similarly sized operator that I could show next to Operator A for comparison.

- What I thought I could do is adding a calculated column in Power BI called "Operator A comparison" and create a DAX statement like" IF Operator = "Operator A" then "Operator A" ; IF Operator = "Operator B" then "Similar Operator"

- Then I would create a bar chart to show failures against time, with the two series "Operator A" and "Similar Operator"

Problem is: what if I then go to Operator B for a presentation? I would like to also have the reversed, i.e. a bar chart with 2 series "Operator B" and "Similar Operator" which would be the anonymised version of "Operator A".

I could in theory create another calculated column with "Operator B" and "Similar Operator" using a similar DAX statement than above, however how can I setup the bar chart to automatically switch to the other calculated column when I am presenting to Operator B, as opposed to presenting to Operator A? Can I setup a "dynamic" slicer that when selected for example to "Operator A" would automatically tell the bar chart to refer to the correct calculated colum, i.e. the one that has "Operator A" and "Similar Operator"?

Thank you.

Date	Operator	Model	Failure index
2-Jan-17	A	Ferrari	2
20-Jan-17	B	BMW	3
31-Jan-17	A	Porche	4
1-Feb-17	C	Ferrari	2
23-Feb-17	D	Ferrari	3
24-Feb-17	C	BMW	45
18-Mar-17	A	Porche	23
19-Mar-17	A	Ferrari	2
10-Apr-17	C	Porche	13
11-Apr-17	B	BMW	5
3-May-17	B	Ferrari	4
4-May-17	D	Ferrari	2
26-May-17	D	Ferrari	2
27-May-17	A	Porche	3
18-Jun-17	D	BMW	4
19-Jun-17	A	BMW	6
11-Jul-17	C	Porche	4
12-Jul-17	B	Ferrari	3
3-Aug-17	C	Porche	23
4-Aug-17	D	BMW	45
26-Aug-17	C	BMW	7
27-Aug-17	A	Porche	65
18-Sep-17	C	Porche	4
19-Sep-17	D	Ferrari	43
11-Oct-17	B	Porche	45
12-Oct-17	A	BMW	6
3-Nov-17	C	Ferrari	5
4-Nov-17	D	Porche	33
26-Nov-17	F	Ferrari	4
27-Nov-17	C	Porche	5
19-Dec-17	B	BMW	54
20-Dec-17	B	Ferrari	3

[Vvelarde]

@Anonymous

Note: To a Quick result First you can filter A & B Operator.

Hi You can use Parameters:

After That Use a Conditional Column:

Close & Apply

Now in your Chart

Now to change to Operator B

OK. Apply Changes 

And your chart look now:

Regards

Victor

Lima -Peru

[Anonymous]

Thanks Victor,

  That way the "Similar" operator is everybody but A. I would like only Operator B to be the "similar operator" and would like to exclude all the other operators.

[Vvelarde · Accepted solution]

@Anonymous

Hi. the Quick Way is Filter A & B Operator in The Editor.

Victor

[Anonymous]

Great! Thanks a lot.