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 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?

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

4 Replies

  • 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

  • Paulien_'s avatar
    Paulien_
    Frequent Visitor
    4 years ago

    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. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    amitchandak 

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

     

    Thanks.

    Thanks Paulien_ 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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 ?