Forum Discussion
Customize pop up warning when insufficient data after slicer selection
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 ...
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
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 ?