Show multiple measures based on single slicer selection in power bi

[adityapv]

Hi,I have created 4 measures 

1.sales A

2.sales B

3.Profit A

4.Profit B

Now i need to display these  measures in line graph.

Requirement:Slicer contains two fields 1.Sales 2.Profit

1.when i select Sales in slicer i need to display sales A and Sales B measures in line graph

2.when i select Profit in slicer i need to display Profit A and Profit B measures in line graph.

tried with switch condition but its not working please help me with this scenario

[amitchandak · Accepted solution]

@adityapv , You need to create two measures

A = Switch(SELECTEDVALUE(Slicer[Slicer]) ,

"Sales", [Sales A] ,

"Profit", [Profit A]

)

B= Switch(SELECTEDVALUE(Slicer[Slicer]) ,

"Sales", [Sales B] ,

"Profit", [Profit B]

)

use both in a visual

refer if needed

measure slicer
https://www.youtube.com/watch?v=b9352Vxuj-M
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...

[adityapv]

Hi amit,thank you so much.your solution is working.

[adityapv]

Spoiler

Hi,

Thanks for response.but my requirement is different.

Slicer having 1.sales 2.profit

If I select sales then I need to display sales A and sales B

If I select profit then I need to display profit A and profit B.please help me with this scenario