topic Re: Slicer Affecting Only Certain column in a Matrix in DAX Commands and Tips

Slicer Affecting Only Certain column in a Matrix

vinayguptak — Sat, 08 Apr 2023 03:25:27 GMT

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.

Re: Slicer Affecting Only Certain column in a Matrix

Jihwan_Kim — Sat, 08 Apr 2023 04:16:21 GMT

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 )

Re: Slicer Affecting Only Certain column in a Matrix

vinayguptak — Sat, 08 Apr 2023 22:02:43 GMT

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.

Re: Slicer Affecting Only Certain column in a Matrix

Jihwan_Kim — Sun, 09 Apr 2023 06:03:53 GMT

Hi,

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

Thank you.

Re: Slicer Affecting Only Certain column in a Matrix

vinayguptak — Sun, 09 Apr 2023 13:57:03 GMT

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