ChicletSlicer

[Staless]

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

[v-yuezhe-msft · Accepted solution]

@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]

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.