Changing Column based on Slicer selection

Question

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.&nbsp;For Example:&nbsp;Name Last3Months Last6Months Last9MonthsA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4&nbsp;If the "Last 3 Months" slicer is selected, I'd like to see a visual table in the format of:&nbsp;Name CountA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp;If the "Last 6 Months" slicer is selected, I'd like to see a visual table in the format of:&nbsp;Name CountA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3&nbsp;&nbsp;Hopefully that made sense!&nbsp;

v-danhe-msft · Accepted Answer

Hi&nbsp;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.
&nbsp;
Regards,
Daniel He

Forum Discussion

Changing Column based on Slicer selection

1 Reply

Related content

Change in category selection changes selected subcategory in slicers

Calculated table column values changes on slicer selection

Variance column for Dynamically selected columns

Single Selection of aggregated columns

Change Table Columns Based on Slicer Selection