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!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.