Forum Discussion

arashaga's avatar
arashaga
Helper I
7 years ago
Solved

Issue with Slicing data based on the columns

Hi I have a table as below. I would like to know how to use the slicer in such a way that when I pick Year 1, it would give me a barchart with ony Year1_Median, Year1_P25 and Year1_P75 and when I pic...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Try unpivoting your table through the "Query Editor". 

     

    1. Edit table

    2. Select column name "inst_name" and right click on the column header

    3. Select "Unpivot Other Columns"

     

    You'll get an "attribute" Column which will contain values such as your column headers (Year1_Median, Year1_P25, Year1_P75 etc.) and then a "Value" Column which will be the corresponding dollar amount.

     

    Hopefully that helps!

    Derek G

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Try unpivoting your table through the "Query Editor". 

 

1. Edit table

2. Select column name "inst_name" and right click on the column header

3. Select "Unpivot Other Columns"

 

You'll get an "attribute" Column which will contain values such as your column headers (Year1_Median, Year1_P25, Year1_P75 etc.) and then a "Value" Column which will be the corresponding dollar amount.

 

Hopefully that helps!

Derek G