Visual displaying blank data

[Anonymous]

I am experiencing variation in seemingly identical visualisations: 

These two are linked to different data, but the same Date Hierarchy filter. 

The below is showing May-December 2022, but the top is not; there's no data in the future for either. 

The table relationship to the Calendar Table with the date filter looks the same, but I am not an expert and I suspect that's where the problem is. 

Does anyone have any suggestions of where to look to iron out the difference? 

[SpartaBI · Accepted solution]

Well...that could be one reason..

Maybe the measure in the top chart shows blank where there is no data (default behaviour) and the measure in the bottom charts show 0, for exanple in that measure there is addition of 0 to the number somewhere in the calculation, which will cause the value to not blank. In this case you will 0 values for all data points that will appear in your chart

[Anonymous · Accepted solution]

Hi @Anonymous ,

I have create a simelp sample, please refer to my pbix file to see if it helps you.

I can think of two reasons why this might be the case：

1. Data with future data in it. Like the following screenshot:

       2. The dax operation may contain 0. Like the following screenshot:

Please check my measure.

Measure_2 =
CALCULATE (
    SUM ( Table_2[value] ),
    FILTER ( ALL ( Table_2 ), Table_2[Column] = SELECTEDVALUE ( 'Table'[Column] ) )
) + 0

If I have misunderstood your meaning, please provide you pbix file without privacy information and your desired output.

Best Regards

Community Support Team _ Polly

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

[Anonymous]

I hadn't tried that, but toggling it has no impact on the display, no. 

[SpartaBI]

In both visuls it's the same date table and same meausre?

Did you toggle 'show items with no data' on the bottom chart visual settings

[Anonymous]

It's the same date table, but a different measure taken from different data tables. 

[SpartaBI · Accepted solution]

Well...that could be one reason..

Maybe the measure in the top chart shows blank where there is no data (default behaviour) and the measure in the bottom charts show 0, for exanple in that measure there is addition of 0 to the number somewhere in the calculation, which will cause the value to not blank. In this case you will 0 values for all data points that will appear in your chart