Forum Discussion

luv3yin's avatar
luv3yin
Frequent Visitor
7 years ago

Slicer

Hi, i have a standard cateogry as below. But i would like to have a slicer for special category which is combination from few category/sub-category. Please advice how to do it?

 

Dataset:

CategorySub-category
A10
A20
A30
B40
B50
B60
C70
C80
C90

 

Special category:

XXX : everything in A and B40

YYY: everything in B and C90

ZZZ: A10, B10, C10

 

Thanks.

Need Help

2 Replies

  • Nishantjain's avatar
    Nishantjain
    Continued Contributor
    7 years ago

    luv3yin 

     

    Have you tried creating a calculated column and use that as in your slicer?

     

    Thanks

    Nishant

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support
    7 years ago

    hi, luv3yin 

    Special category:

    XXX : everything in A and B40

    YYY: everything in B and C90

    ZZZ: A10, B10, C10

    What is your logic of it?

    for ZZZ: A10, B10, C10, are these two columns independent?

    Could you show the expected output with different scenario?

     

    Best Regards,

    Lin