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

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