Customize pop up warning when insufficient data after slicer selection

[Anonymous]

I have a regular PowerBI report with some slicers.   The challenge is that when number of rows selected based on a slicer gets below a certain threshold (say less than 20 rows), I want to display warning message like "Insufficient data to display".   The reason is that the visual based on the 20 rows threshold does not provide a good guide/representation. 

Is there any link to a similar solution for this?

[Anonymous]

This works fine for the display of the "Insufficient data to display" message.  But I will like to hide the entire page background when this message is displayed so that onlly the message shows while the rest of the visuals are blured.  Any suggestion ?

[Anonymous]

@amitchandak 

This seems workable. I  will try to implement before end of week and ket you know.

Thanks.

Thanks @Paulien_ 

[Paulien_]

I would create a measure that counts the rows with either count or countrows, e.g. CountRowsInTable
Then I would add an "IF" statement around the measure, saying: IF (CountRowsInTable< 20, "Insufficient data to display", "") and add this to a card visual. 

[amitchandak · Accepted solution]

@Anonymous , You can create measure like

measure = if( countrows(Table)< 20, "Insufficient data to display",  blank())

color measures

measure font = if( countrows(Table)< 20, "#000000" ,  "#FFFFFF00") 

measure background= if( countrows(Table)< 20, "#FFFFFF" ,  "#FFFFFF00") 

You can have this measure in card and use color on font and background , that can show hide based on value

#FFFFFF00 - transparent color