Changing Column based on Slicer selection

[nzcatala]

I have summarized data that is broken into categories by date, and I would like to be able to select between the three columns based on a data slicer.

For Example:

Name Last3Months Last6Months Last9Months

A         1                      2                    3

B         2                      3                    4

If the "Last 3 Months" slicer is selected, I'd like to see a visual table in the format of:

Name Count

A         1

B         2

If the "Last 6 Months" slicer is selected, I'd like to see a visual table in the format of:

Name Count

A         2

B         3

Hopefully that made sense!

[v-danhe-msft · Accepted solution]

Hi @nzcatala,

Based on my test, you could refer to below steps:

Unpivot your row table with these three columns:

Result:

Now you could use the [Attribute] column as filter:

You could also download the pbix file to have a view.

Regards,

Daniel He