Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

DAX Parameter Selected Value

Hi , My requirement is dynamically switch between different demographic categories using the slicer, display their proportions over time on the line chart, and add a reference line to show the gap f...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous 

     

    I have tested your problem and your code seems to be fine. The key to the problem lies in the creation of visual objects.

     

    I suggest you create two visual objects that show the data corresponding to different parameters.

     

    Select "Gender"

     

    Select "Age"

     

     

    Select "line chart", "Year" in the x axis, "SelectedCategoryProportion" into the y axis.

     

    It should be noted that "Gender" and "Age" are placed into the "Small multiples" of the two visual objects respectively.

     

                     

     

    At the same time, you can adjust the visual object to two rows and one column.

     

     

    Regards,

    Nono Chen

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