Graph showing data that doesn't exist

[Spotto]

hello everyone, I have a measure that makes the accumulated percentage of an average (graph), but when I select a name that does not have the date 09/06 the graph shows the date even though it is without value, is there any form of the graph not show date that doesn't exist when selected?

Meta_Acum_Analista = CALCULATE(

    AVERAGE(base_Meta_Atingida_Diaria[META_DIARIA_ATINGIDA]),

    FILTER(ALL(base_Meta_Atingida_Diaria[DATA_DAILY_META]),

    base_Meta_Atingida_Diaria[DATA_DAILY_META]<=MAX(base_Meta_Atingida_Diaria[DATA_DAILY_META])

    )

)

Select name ALISSON S: 

the date 09/06 does not exist for ALISSON but it continues to show in the graph

Thank you for your help

[Anonymous · Accepted solution]

Hi @Spotto ,

It sounds like you're trying to create a Power BI measure that calculates the accumulated percentage of an average, but you're having trouble with the graph displaying dates that don't have any values. One way to solve this issue is to modify your measure to include a filter that excludes dates that don't have any values. You can do this by adding an additional condition to your FILTER function that checks if the date has any values before including it in the calculation. Here's an example of how you could modify your measure:

Meta_Acum_Analista =
CALCULATE (
    AVERAGE ( base_Meta_Atingida_Diaria[META_DIARIA_ATINGIDA] ),
    FILTER (
        ALL ( base_Meta_Atingida_Diaria[DATA_DAILY_META] ),
        base_Meta_Atingida_Diaria[DATA_DAILY_META]
            <= MAX ( base_Meta_Atingida_Diaria[DATA_DAILY_META] )
            && COUNTROWS (
                FILTER (
                    base_Meta_Atingida_Diaria,
                    base_Meta_Atingida_Diaria[DATA_DAILY_META]
                        = EARLIER ( base_Meta_Atingida_Diaria[DATA_DAILY_META] )
                )
            ) > 0
    )
)

This modified measure includes an additional condition that checks if the count of rows with the selected date is greater than 0 before including it in the calculation. This should prevent the graph from displaying dates that don't have any values.

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

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

[Spotto]

@Anonymous tks for your help , but but I put your measurement suggestion and the graph keeps showing the day 09/06 with no value

I'll leave an example of the file so you can analyze it, thanks again for the help
example.pbix