Forum Discussion
Making a Slicer from Categories not in a Column
You could use unpivoting here. Choose all the measurement columns, and then unpivot them (Transform>Unpivot Columns), so that the column names go into one column, and another column will contain corresponding values in it. The only thing to remember is that if you had a single row for each month, now you will have several rows for each month. However, this is not an issue for visualizations and slicers, as they group the underlying data.
Advocate IYou could use unpivoting here. Choose all the measurement columns, and then unpivot them (Transform>Unpivot Columns), so that the column names go into one column, and another column will contain corresponding values in it. The only thing to remember is that if you had a single row for each month, now you will have several rows for each month. However, this is not an issue for visualizations and slicers, as they group the underlying data.
Thank you so much! Worked like a charm