Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 ...
Need Help
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    4 years ago

    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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

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