Missing Values ​​in a Bar Chart

[Anonymous]

Dear all,

I have a problem with some missing data ​​in my chart.

Blue bars refer to data from a direct query, and they are correct.
The others are from an excel sheet but is missing the data when i don't have data from direct query, as you can see in the picture.

Thanks for your help

[v-lid-msft]

Hi @Anonymous ,

We can try to create a claculated table which contain all the hours as the x-axis field to meet your requirement after create relation with the origin table

Start Of Hour Axis = ADDCOLUMNS(GENERATESERIES(0,23,1),"Start Of Month",[Value] & ":00")

 If it doesn't meet your requirement, could you please share the formula of Contagem de peso if it does not contain any confidential information? Please don't have any Confidential Information or Real data in your reply.

Best regards,

[Anonymous]

@v-lid-msft there is no formula, they are just data. I just choose count to count the number of entries.

[v-lid-msft]

Hi @Anonymous ,

What is the data type of the "Start  of Hour" column? How about the result of  using the calculated table as the Sharde Axis field?

Best regards,

[Anonymous]

Someone can help me? plz

[amitchandak]

Drag the measures/field to visual level filter and put condition >0

[Anonymous]

@amitchandak how i do that?