Making a Slicer from Categories not in a Column

[mkuhnel]

Hello,

Just a quick question about slicers here. I currently have data set up in the following manner:

Month Column | One Measurement | More Measurements | etc

I want to able to use this data to create a slicer where I can select a measurement and view how they change between months. However, since there isn't a column with just the measurements in it, I am stuggling to do this. I can transpose my data set but then my months are individual columns and I don't know how to plot a trend once I do that. Please let me know how I should go about this. 🙂

Thanks

[foyiq · Accepted solution]

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.

[mkuhnel]

Thank you so much! Worked like a charm