Hi,I have created 4 measures
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
Go to 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-Mhttps://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...
View solution in original post
Hi amit,thank you so much.your solution is working.
Click here to read more about the November 2022 updates!
Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.