Right visualisation to show an alert / notification

[Anonymous]

We have a Power BI Dashboard with a date-time slicer. The requirement from our users is to show an alert / notification / message if the data available for the selected data-range isn't sufficient. If there is enough data, the charts/calculations will be done.

What is the best Power BI visual to do the former? That is, how do we show a message above the slicer stating (e.g.) "Insufficient data, extend your date range"? Any suggestions?

[v-stephen-msft · Accepted solution]

Hi @Anonymous ,

You can try to determine the number of rows to return the result.

For example, if there are less than 3 pieces of data, it will display: "Insufficient data, extend your date range", and if it is greater than or equal to three pieces of data, the result will be calculated.

Sample data:

Measure:

Measure = IF(COUNTROWS('Table')>=3,CALCULATE(SUM('Table'[Value]),ALLSELECTED('Table')),"Insufficient data, extend your date range")

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.