Slicer Affecting Only Certain column in a Matrix

[vinayguptak]

Hi.  I am running in to a bit of a maze.  I am trying to create a matrix where only certain columns are affected by the slicer.  For example: If I select previous year (2022), then my first column should change, but 2 column, which is my current year (2023) data shouldn't change.

Is this possible?  Any suggestion would be highly appricated.  Thank you.

[vinayguptak]

@Jihwan_Kim Thank you so much for the suggestion and help.  I was able to figure out.

[Jihwan_Kim]

Hi,

I am not sure how your datamodel looks like, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

I hope the below can provide some ideas on how to create a solution for your datamodel.

Original qty by slicer: = 
CALCULATE ( SUM ( Sales[Qty] ), Category[Category] = "Original" )

Replaced qty in 2022 =
CALCULATE (
    SUM ( Sales[Qty] ),
    Category[Category] = "Replaced",
    'Calendar'[Year] = 2022
)

[vinayguptak]

@Jihwan_Kim Thank you so much for the suggestion.  I have one more question.  So the first section which is highlighted in Orange, should change and the 2nd column which is YTD shouldn't change.

Also, the YTD is dynamic year so in 2024, it will display that years data.  Can I use MAX(Year) to pull the current year.

Also, both column should if slicer Replacement Reason is selected.

[Jihwan_Kim]

Hi,

Please share your sample pbix file's link, and then I can try to look into it.

Thank you.