how to add warning message if select all checkbox clicked on slicer

kp27 — Sat, 28 Sep 2024 00:22:40 GMT

Hi All,

When I choose select all checkbox in slicer, Data in visual is reaching its limit,So I'm trying to add warning message if select all check box is clicked.

Steps I followed, I tried creating DAX and adding warning message in it . And added card visual to implement the warning message but this method doesnt helps.s there is any way to resolve it.

Thanks in Advance.

Re: how to add warning message if select all checkbox clicked on slicer

Anonymous — Mon, 30 Sep 2024 05:02:04 GMT

Hi,kp27 .I am glad to help you.

You can refer to my test case below where I use several common slicer processing approaches:
switch dynamically returns different cases, filtering the data based on the meausre value (set the value of the filter function's measure in filters = 1)
slicer multiple choice: using the values function
slicer options splicing: use the string concatenation function will be the target slicer in the selected value spliced into a string and to determine whether each line of data in the string

Here is my test code:

cardWarning = VAR _slicerValue= VALUES('SlicerTable'[slicerData]) VAR _slicerTable=CALCULATETABLE( VALUES('data_refreshTest'[refreshPoint]),FILTER( ALLSELECTED('data_refreshTest'),'data_refreshTest'[refreshPoint] in _slicerValue) ) VAR _slicertext= CONCATENATEX(VALUES('SlicerTable'[slicerData]), 'SlicerTable'[slicerData], ", ") VAR TotalValuesRows = COUNTROWS(ALL('SlicerTable'[slicerData])) VAR SelectedValuesRows = COUNTROWS(VALUES('SlicerTable'[slicerData])) VAR _ifSelectedALL=IF(TotalValuesRows = SelectedValuesRows, 1, 0) VAR _ifSelectedNone=IF(SelectedValuesRows=0 ,1 , 0) VAR _today=TODAY() VAR _threemonthsago=EOMONTH(_today,-3)+1 VAR _onemonthago=EOMONTH(_today,-1)+1 VAR _oneweekago=_today -7 VAR _tableDatePoint =MAX('data_refreshTest'[refreshPoint]) VAR _value01=CALCULATE(MAX('data_refreshTest'[refreshPoint]),FILTER('data_refreshTest','data_refreshTest'[refreshPoint]=_today)) VAR _value02=CALCULATE(MAX('data_refreshTest'[refreshPoint]),FILTER('data_refreshTest','data_refreshTest'[refreshPoint]<=_today && 'data_refreshTest'[refreshPoint]>= _oneweekago)) VAR _value03=CALCULATE(MAX('data_refreshTest'[refreshPoint]),FILTER('data_refreshTest','data_refreshTest'[refreshPoint]<=_today && 'data_refreshTest'[refreshPoint]>= _onemonthago)) VAR _value04=CALCULATE(MAX('data_refreshTest'[refreshPoint]),FILTER('data_refreshTest','data_refreshTest'[refreshPoint]<=_today && 'data_refreshTest'[refreshPoint]>= _threemonthsago)) RETURN SWITCH(TRUE(), _ifSelectedALL=1,"warning:Please do not select “Selected All Or select other options on the slicer", CONTAINSSTRING(_slicertext,"three months ago"),IF(_tableDatePoint=_value04,1,0), CONTAINSSTRING(_slicertext,"a month ago"),IF(_tableDatePoint=_value03,1,0), CONTAINSSTRING(_slicertext,"a week ago"),IF(_tableDatePoint=_value02,1,0), CONTAINSSTRING(_slicertext,"nowadays"),IF(_tableDatePoint=_value01,1,0) )

The slicer table:

The test data:

When the slicer does not make a selection (default select all), or when you click selected all, the system prompts an error message:

When the corresponding month filter date is selected, the data for the corresponding date is displayed using the markup result of measure:

I also found the article that meets your needs and have uploaded the test file, I hope it helps.

URL:
Display Custom Message in the Visual Until a Selec... - Microsoft Fabric Community

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

topic Re: how to add warning message if select all checkbox clicked on slicer in Report Server

how to add warning message if select all checkbox clicked on slicer

Re: how to add warning message if select all checkbox clicked on slicer