DAX to compare last 12 months with 2019

[sanjeet94]

I'm trying to develop a clustered column chart to visualise category wise revenue for last 12 months with 2019. The problem comes when using a drop down if I select any specific month from last 12 months, the bar for 2019 revenue doesn't change and stays at the default state (of yearly revenue).

[Ashish_Mathur]

Hi,

Share some data to work with and show the expected result.

[sanjeet1299]

You can assume any typical sales data at product_id, invoice_date & sales level. Can't share the snippet of data due to privacy issues and expected result is on PowerBI that when I select any month from last 12 months say Jan'22, the clustered column chart that has two bars one for last 12 months & 12 months of 2019 should reflect for Jan 2022 & Jan 2019. See images for the issueDefault for entire 12 months (last 12 months & 2019)

Expected 55M to go down for Jan'19 which isn't happening

 @Ashish_Mathur 

[Ashish_Mathur]

I cannot help you without having access to a dataset.  Create a dummy dataset and show the expected result in a simple table format.

[sanjeet1299]

@amitchandak would you like to give it a try?