Separate Series On Chart With Different Year

[MCassady]

I have a table called FactRawData. It is being filtered by the following slicers:

The following chart, shows the values from factrawdata, for 2018.

 

I would like to add a second series on this graph, that is the data from the same table, for the selected year in the "Baseline year" slicer, however I can't seem to get the data to show on the graph. 

Below is my custom measure.

 

I have a feeling I need to use ALL, since the slicers forthe first series would be affecting this measure...but I am not sure I am doing it right, since that data does not appear on my graph.

[v-chenwuz-msft · Accepted solution]

Hi @MCassady 

Please try to create slicer using two separate tables.

Then create measures for the line chart, one line one measure.

year1 =
CALCULATE (
    SUM ( 'Fact Table'[values] ),
    FILTER (
        ALLSELECTED ( 'Fact Table'[Date].[Year] ),
        [Date].[Year] = MAX ( 'Slicer1'[Year] )
    )
)

year2 =
CALCULATE (
    SUM ( 'Fact Table'[values] ),
    FILTER (
        ALLSELECTED ( 'Fact Table'[Date].[Year] ),
        [Date].[Year] = MAX ( 'Slicer2'[Year] )
    )
)

Result:

Pbix in the end you can refer.

Best Regards

Community Support Team _ chenwu zhu

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

[ronaldbalza2023]

Hi @MCassady , hope you are having a great day. Reason is that Power BI is confused on what you are trying to do having those 2 slicers (Year and Baseline Year). My suggestion is to have a month & year column on your date table and place it on your visuals to have the "series" kind of effect. 😉

How to Create a Month Year Column in Calendar