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

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.