Forum Discussion
Solved
Changing Column based on Slicer selection
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 Last6Month...
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
v-danhe-msft
Microsoft Employee
Microsoft EmployeeHi 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