Forum Discussion

puru85's avatar
puru85
Helper II
2 years ago
Solved

Multi-Select Measures in Line Chart

Hello Experts, I have a requirement to display default measures, "Total Sales" and "Total Profit," in a Line chart, which I have successfully achieved. Additionally, I am able to dynamicall...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi puru85 ,
    Thanks for mh2587 and parry2k reply.
    Here's what I want to add:
    Create a Filed Parameter

    Create a column in Parameter table

    Measure Name = 
    IF(
        Parameter[Parameter] = "Discount",
        "Discount",
        "Qty"
    )

     

     


    Create relationship between "Parameter[Measure Name]" and “Dynamic Measure[Measures]”

     

    Create a measure

    Measure = 
    IF(
        SELECTEDVALUE('Dynamic Data'[Measures]) IN VALUES(Parameter[Measure Name]),
        1,
        0
    )

    Slicer settings


    In line cahrt field use "Total profit","Total Sales",“Parameter”

    Final output

     

    Best regards,
    Albert He

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly