Matrix Help

[JPAnalytics]

Hello All,

Is it possible to replicate the below in a matrix where the rows are actually measures.

I want to be able to use the date slicer based off my calendar table to automatically adjust the below table. For example current the date selected is April 2021 so the below table shows April 2021 and April 2020 (CY and PY columns) however I want these to change to March 2021 and 2020 when I select March 2021.

Cheers,

James

[selimovd]

Hey @JPAnalytics ,

when CY and MTD are columns (what you confirmed), then it's possible:

Display DAX Measures in a Matrix on Rows - What the fact.bi

Then use the matrix visual, let the rows empty, but CY MTD and PY MTD in the columns and the measures as values.

Then activate option "Show on rows":

Then the matrix should look like your example.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[JPAnalytics]

Unforuntely this does not work.

The measures show on rows like you say but the columns do not work, also how would I get the target column?

[v-yalanwu-msft]

Hi, @JPAnalytics ;

You could create a column as follows:

CY PY = IF([yearmonth]=2020,"PY MTD","CY MTD")

and put it into column visualization.

Here is a good example to learn。

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.