Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Missing Values ​​in a Bar Chart

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

 

 

Need Help
Show and Tell

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Someone can help me? plz

  • v-lid-msft's avatar
    v-lid-msft
    Community Support
    6 years ago

    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's avatar
      Anonymous
      Not applicable
      6 years ago

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

       

      • v-lid-msft's avatar
        v-lid-msft
        Community Support
        6 years ago

        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,