Forum Discussion
Slicer: Data values in one table equal column names in another
In your data, you want to make sure that you import it into your model as unpivoted. You can do this in the Query editor under the Tranform area of the ribbon. You want to get your data to be in a format such that each row has the columns Name, State, and Amount.
Once you have that imported you can create a slicer based on your State Column, which will display just a distinct list of your imported state values.
Next you can create a Matrix visual. Put Name into the rows. Put State into the columns and put Amount into value and select the aggregation of Sum.
In your data, you want to make sure that you import it into your model as unpivoted. You can do this in the Query editor under the Tranform area of the ribbon. You want to get your data to be in a format such that each row has the columns Name, State, and Amount.
Once you have that imported you can create a slicer based on your State Column, which will display just a distinct list of your imported state values.
Next you can create a Matrix visual. Put Name into the rows. Put State into the columns and put Amount into value and select the aggregation of Sum.
Anonymous Thank you so much! Unpivoting the individual columns into a single STATE column and using the Matrix visual did exactly what I needed.