cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jdalfonso
Helper I
Helper I

Help please! "No Selection" text from Chiclet Slicer

Hi,

 

I cant figure out how to display in a text box with title = "No Selection" if I dont select any filters from the chiclet slicer:

 

The formula I used is: 

PlanSelection =
VAR _Count = COUNTROWS(VALUES(MICA_Product_Code_Master[Description]))
VAR _Concat = CONCATENATEX(VALUES(MICA_Product_Code_Master[Description]),[Description],", ")
RETURN IF(_Count>3,"Multiple Plan Selection Scorecard",if(_count<3, _Concat & " Scorecard", "No Plan Selected"))
 
The problem is I don't select any values from MICA_Product_Code_Master[Description], the VAR _Count = 50. As such, it displays "Multiple Plans". I want it to become zero ( VAR _Count = 0) so it will appear as "No Selection" and include it in the formula. 
1 ACCEPTED SOLUTION
Eyelyn9
Community Support
Community Support

Hi @jdalfonso ,

 

Sorry for my late reply.

According to my understanding, you want to display

1."No Plan Selected" when there is no selection in Chiclet Slicer;

2. Selections combined by "," and the suffix is "Scorecard" when there are less than or equal 3 selections;

3."Multiple Plan Selection Scorecard" when there are more than 3 selections.

 

If so , you could use ISFILTERED() to check whether a column is being filtered directly :

PlanSelection = 
VAR _Count = COUNTROWS(VALUES(MICA_Product_Code_Master[Description]))
VAR _Concat = CONCATENATEX(VALUES(MICA_Product_Code_Master[Description]),[Description],", ")
RETURN IF(ISFILTERED(MICA_Product_Code_Master[Description]),IF(_Count>3,"Multiple Plan Selection Scorecard",_Concat & " Scorecard"),"No Plan Selected")

Here is the final output:

Eyelyn9_0-1632708244043.png

 

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
Eyelyn9
Community Support
Community Support

Hi @jdalfonso ,

 

Sorry for my late reply.

According to my understanding, you want to display

1."No Plan Selected" when there is no selection in Chiclet Slicer;

2. Selections combined by "," and the suffix is "Scorecard" when there are less than or equal 3 selections;

3."Multiple Plan Selection Scorecard" when there are more than 3 selections.

 

If so , you could use ISFILTERED() to check whether a column is being filtered directly :

PlanSelection = 
VAR _Count = COUNTROWS(VALUES(MICA_Product_Code_Master[Description]))
VAR _Concat = CONCATENATEX(VALUES(MICA_Product_Code_Master[Description]),[Description],", ")
RETURN IF(ISFILTERED(MICA_Product_Code_Master[Description]),IF(_Count>3,"Multiple Plan Selection Scorecard",_Concat & " Scorecard"),"No Plan Selected")

Here is the final output:

Eyelyn9_0-1632708244043.png

 

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!