Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Custom Slicer based on Grouped Cell Values in a column

Hello,   I am trying to create custom slicers that allow me to select a "category" instead of a cell value.    This is what I have currently: a b c a1 b1 c1 a2 b2 c2 a3 b3 c3...
"DAX "
"Need Help"
Power Query
  • Irwan's avatar
    Irwan
    2 years ago

    hello Anonymous 

     

    please check if this accomodate your need.

     

    1. create a calculated column for categories.

    Category =
    IF(
        RIGHT('Table'[a],1)="1"||
        RIGHT('Table'[a],1)="2"||
        RIGHT('Table'[a],1)="5"||
        RIGHT('Table'[b],1)="1"||
        RIGHT('Table'[b],1)="2"||
        RIGHT('Table'[b],1)="5"||
        RIGHT('Table'[c],1)="1"||
        RIGHT('Table'[c],1)="2"||
        RIGHT('Table'[c],1)="5",
        "Category 1",
    IF(
        RIGHT('Table'[a],1)="3"||
        RIGHT('Table'[a],1)="6"||
        RIGHT('Table'[b],1)="3"||
        RIGHT('Table'[b],1)="6",
        "Category 2",
        "Category 3"
    ))

     

    2. plot your data in table visual and the category column in slicer.

     

    Hope this will help you.

    Thank you.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Yes, this worked perfect. Thank you so much!

Irwan's avatar
Irwan
Icon for Super User rankSuper User
2 years ago

hello Anonymous 

 

glad to be a help.

 

Thank you.