Forum Discussion
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...
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,
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
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.