cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Chiclet slicer - select "All"

Hello,

I'm using a Chiclet slicer and would like to add an "All" option.  As far as I can tell, there's no built-in option that allows for that with this visualization.  Is there something I can use as a workaround?

 

Thanks,

Jenna

1 ACCEPTED SOLUTION

Accepted Solutions

Ok, I figured out how to do it.  I don't know if this is the most efficient way but it works, and thought I'd post it in case others ran into a similar problem.

 

Let's say you have a table called "Project Data":

Screen Shot 2018-09-18 at 11.36.45 AM.png

(I used 0 and 1 for "no" and "yes" because I find numbers easier to handle than text in DAX.)

 

Create a second table that includes the values you want in your slicer, called "Slicer Values":

Screen Shot 2018-09-18 at 11.38.16 AM.png

 

Add a new measure:

Project Status Selected =
SWITCH (True(),
VALUES('Slicer Values'[Selection]) = "All Projects", "Show",
VALUES('Slicer Values'[Selection]) = "New Projects Only" && SUM('Project Data'[Is Project New?]) = 1, "Show",
VALUES('Slicer Values'[Selection]) = "Old Projects Only" && SUM('Project Data'[Is Project New?]) = 0, "Show",
"No")

 

This measure looks at both the user's selection and the "Is Project New?" column to evaluate whether each project should be "Show" or "No".

 

Create a visualization with the project name and revenue, and add the "Project Status Selected" measure as a visual filter:

Screen Shot 2018-09-18 at 11.44.58 AM.png

 

Add a slicer using the "Selection" field in your "Slicer Values" table, and now you can use it to select All Projects, New Projects Only, or Old Projects Only on your visualization:

 

Screen Shot 2018-09-18 at 11.46.36 AM.pngScreen Shot 2018-09-18 at 11.46.44 AM.pngScreen Shot 2018-09-18 at 11.46.49 AM.png

View solution in original post

6 REPLIES 6
Resident Rockstar
Resident Rockstar

HI @jhoffstein

 

  Am not sure about chiclet slicer, but in the normal slicer, if you see Visualization->"Format" Tab, you can "Show all Option" under "Selction controls"  section. You may have something like this , which you can try.

 

Thanks

Raj

Community Support
Community Support

Hi jhoffstein,

 

From the github, we can see options which Chiclet slicer support:

 

  • Multiple selection: If this option is turned on you will be able to select chiclets without Ctrl button. (It will be usefull for multiple selection on mobile devices) If this option is turned off you have to use Ctrl button for multiple selection.

 

  • Forced selection: This setting forcibly select first item and doesn't allow to unselect any chiclet item.

So currently there's no "all" options in this custom visual, you can contact with the author about adding this feature.

 

Regards,

Jimmy Tao

Hi @rajendran - That's not an option for the Chiclet slicer, unfortunately.

 

Thanks,

Jenna

Frequent Visitor

To clarify my question a bit - is there something I can do with my data, or some DAX code that I can use to get the desired result?

 

Thank you,

Jenna

Ok, I figured out how to do it.  I don't know if this is the most efficient way but it works, and thought I'd post it in case others ran into a similar problem.

 

Let's say you have a table called "Project Data":

Screen Shot 2018-09-18 at 11.36.45 AM.png

(I used 0 and 1 for "no" and "yes" because I find numbers easier to handle than text in DAX.)

 

Create a second table that includes the values you want in your slicer, called "Slicer Values":

Screen Shot 2018-09-18 at 11.38.16 AM.png

 

Add a new measure:

Project Status Selected =
SWITCH (True(),
VALUES('Slicer Values'[Selection]) = "All Projects", "Show",
VALUES('Slicer Values'[Selection]) = "New Projects Only" && SUM('Project Data'[Is Project New?]) = 1, "Show",
VALUES('Slicer Values'[Selection]) = "Old Projects Only" && SUM('Project Data'[Is Project New?]) = 0, "Show",
"No")

 

This measure looks at both the user's selection and the "Is Project New?" column to evaluate whether each project should be "Show" or "No".

 

Create a visualization with the project name and revenue, and add the "Project Status Selected" measure as a visual filter:

Screen Shot 2018-09-18 at 11.44.58 AM.png

 

Add a slicer using the "Selection" field in your "Slicer Values" table, and now you can use it to select All Projects, New Projects Only, or Old Projects Only on your visualization:

 

Screen Shot 2018-09-18 at 11.46.36 AM.pngScreen Shot 2018-09-18 at 11.46.44 AM.pngScreen Shot 2018-09-18 at 11.46.49 AM.png

View solution in original post

Anonymous
Not applicable


  • Multiple selection: If this option is turned on you will be able to select chiclets without Ctrl button. (It will be usefull for multiple selection on mobile devices) If this option is turned off you have to use Ctrl button for multiple selection.
  • Forced selection: This setting forcibly select first item and doesn't allow to unselect any chiclet item.

There is also apparently no way to prevent multiple selection / enforce single selection.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors