Forum Discussion

cjsund's avatar
cjsund
New Member
1 year ago
Solved

Merging multiple TotalYTD visualizations.

Hi everyone,   I have a tracking sheet for 4 different stages of work, and each stage has it's own respective totalYTD visual.  But now I want to have a single visual that shows all 4 stages on one...
  • Anonymous's avatar
    Anonymous
    1 year ago

    Thanks for the reply from amitchandak , please allow me to provide another insight:

    Hi  cjsund ,

    I created four tables and four corresponding measure:

    Here are the steps you can follow:

    If you want to display the values of all four line charts on the same axis, you can simply create a table of dates to be used as a bridge table with the dates of the other four tables in a join relationship.

    Using the Line chart, use the [Date] of the date table for the X-axis, and place the four measures in the Y-axis.

    If you want to display different four line charts in the same visual, you can try to create a Group_Table and place it in Small multiples using [Group] as a category.

    Enter data – create a table.

    Create measure.

    Measure =
    SWITCH(
        TRUE(),
        MAX('Group_Table'[Group])= "Measure1",[Measure1]
        MAX('Group_Table'[Group])= "Measure2",[Measure2],
        MAX('Group_Table'[Group])= "Measure3",[Measure3],
        MAX('Group_Table'[Group])= "Measure4",[Measure4]
    )

     

     

    Best Regards,

    Liu Yang

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