Forum Discussion

S_D's avatar
S_D
Frequent Visitor
8 years ago
Solved

Slicer based on multiple columns

Hi,   I have a list of agencies belonging to 7 different types. In my report, I want to filter my graph by selecting one of the types of agency. But my problem is that an agency can belong to mult...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi S_D,

     

    In that case, I'm afraid your requirement cannot be achieved. Because we can only add a column into slicer, all slicer items that we can choose are deatiled values belong to this column. If we don't unpivot the table structure to convert agency type into rows, we are not able to filter agency type.

     

    Regards,
    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi S_D,

 

You should unpivot this table in Query Editor mode. Rename the new created field name. Then, you can drag column [AgencyType] into slicer.

 

Best regards,
Yuliana Gu

  • S_D's avatar
    S_D
    Frequent Visitor
    8 years ago

    Hi,

     

    That's a solution for making the slicer, but now I have duplicate records. For example, the column income has sometimes multiple records for one agency. So, the total sum of income will not be correct of I set the slicer to "all", it wil only be correct if a select an agency. 

     

     

    • v-yulgu-msft's avatar
      v-yulgu-msft
      Microsoft Employee
      8 years ago

      Hi S_D,

       

      In that case, I'm afraid your requirement cannot be achieved. Because we can only add a column into slicer, all slicer items that we can choose are deatiled values belong to this column. If we don't unpivot the table structure to convert agency type into rows, we are not able to filter agency type.

       

      Regards,
      Yuliana Gu