Graph showing data that doesn't exist

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.