Dont show Chart when is too filtered, and has few data

[Anonymous]

Hello everyone, 

I m using a base of customer behavior  that allows many types of filter. If i use many filters, sometimes the chart is made from too few data, and the information is no longer reliable. Is there a way to dont show the plot if i have few data depending on the granularity?

Thanks 

[v-jiascu-msft]

Hi @Anonymous,

Can you share a sample, please? Please mask the sensitive data first. 

The solution could be adding a condition in a measure. It's dynamic. I don't aware any other solutions that would watch the number of results.

Best Regards,
Dale

[Anonymous]

Here is as sample example.pbix

I want to calculate the marketshare of each brand in different cities., the data is based on consumption of different people.  If my base has too few people in a city, i dont want to calculate de marketshare.

If i use a formula like this, it ll evaluate for every brand (in legend) and not the whole chart.

Thanks

Share =
VAR min_id =
    DISTINCTCOUNT ( base[ID_client] )
RETURN
    IF (
        min_id > 5;
        SUM ( base[Total] ) / CALCULATE ( SUM ( base[Total] ); ALL ( base[Brand] ) )
    )

[Anonymous · Accepted solution]

Share =
VAR min_id =
    CALCULATE(DISTINCTCOUNT ( base[ID_client] ); ALL ( base[Brand] ))
RETURN
    IF (
        min_id > 5;
        SUM ( base[Total] ) / CALCULATE ( SUM ( base[Total] ); ALL ( base[Brand] ) )
    )

this worked, thanks