Forum Discussion

Patcha's avatar
Patcha
New Member
4 years ago

data missing from chart but shown in table

I drop 1 measurement data into table and stack chart , some data point is missing from chart but display correctly in table

First screenshot is what data shown in table and 2nd screenshot is what the data missing from chart 

Circled data is shown in table but not showing value in the chart and total in chart also only 30 which the accurate one as in table is 50

 

 

Only 2 data shown in stack bar chart , 

 

 

 

3 Replies

  • Hi Patcha ,

     

    Looking at the information you provide is difficult to pin point the problem question that I see are:

    • You are using the incorrect metrics in the chart
    • The split on the chart is different from the one on the table, meaning you are not placing on the chart the same columns to do the x-axis has you have in the table for the rows.

     

    • Patcha's avatar
      Patcha
      New Member

      Hello MFelix ,

       

      Thank you so much for your kind advise.

      I put the same measurement data into table and chart but missing only 1 data point in the chart .

      Please kindly refer to the full chart data display and table in screenshot below.

      In this case, could you please kindly also advise how to turn the measurement data into column data.

      Thank you so much for your kind advise in advance.

       

      • MFelix's avatar
        MFelix
        Super User

        HI  Patcha ,

         

        On the image is not very clear what rows match each value. How are the values calculated?

         

        Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

        If the information is sensitive please share it trough private message.