Forum Discussion

Staless's avatar
Staless
Regular Visitor
8 years ago
Solved

ChicletSlicer

Hi there,

 

I have question regarding Chiclet Slicer.

I have now 4 categories to show and it is working correctly.

 

 

AIV <250, AIV< 500, AIV<1000 and AIV >= 1000.

I want slicer to work the way, when I click AIV < 500 - it will show AIV < 500 and AIV <250 too.

In short words the interval selection, now it is showing AIV < 500 like 499, 498, 487 ... 250.  It will not include values that are less then 250 and it should. I have to select multiple choice and click on AIV < 500 and click on AIV < 250 (means to click 2x).

 

 

Any ideas?

The current formula is:

 

AIV Description = if(D_Cost[AIV]<250,"4. AIV (<250)",if(D_Cost[AIV]<500,"3. AIV (<500)",if(D_Cost[AIV]<1000,"2. AIV (<1000)",if(1=1,"1. AIV (>=1000)",blank()))))

 

Thank you for your support,

 

Tomas

 

 

 

  • Anonymous's avatar
    Anonymous
    8 years ago

    Staless,

    Create a new table as below.


    Create the following measures in your original table. Also drag the Measure to visual level filter of your visual and set its value to 1.

    Selected Measure = 
VAR MySelection =
SELECTEDVALUE ( Table1[Column1], 1 )
RETURN
SWITCH (
TRUE (),
MySelection = "4. AIV (<250)", 250,
MySelection = "2. AIV (<1000)", 1000,
MySelection = "3. AIV (<500)", 500,
BLANK()
)

     

    Measure = IF(MAX(D_Cost[AIV])<[Selected Measure]||(ISBLANK([Selected Measure]) &&MAX(D_Cost[AIV])>=1000),1,0)


    For more details, please check attached PBIX file.

    Regards,
    Lydia

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Staless,

    Create a new table as below.


    Create the following measures in your original table. Also drag the Measure to visual level filter of your visual and set its value to 1.

    Selected Measure = 
VAR MySelection =
SELECTEDVALUE ( Table1[Column1], 1 )
RETURN
SWITCH (
TRUE (),
MySelection = "4. AIV (<250)", 250,
MySelection = "2. AIV (<1000)", 1000,
MySelection = "3. AIV (<500)", 500,
BLANK()
)

     

    Measure = IF(MAX(D_Cost[AIV])<[Selected Measure]||(ISBLANK([Selected Measure]) &&MAX(D_Cost[AIV])>=1000),1,0)


    For more details, please check attached PBIX file.

    Regards,
    Lydia

    • Staless's avatar
      Staless
      Regular Visitor
      7 years ago

      Hi Lydia, 

       

      thank you for your message and I will try later (on holiday now) and let you know, if it is working (it should as what I see in your attached file)

       

      Regards,

       

      T.