Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Line chart not showing same values as table

The data in the line plot does not match the data in the table even though it is the same measure. Can anyone suggest what might be going wrong here ?

 

It should be theoretically impossible to create negative values given the Rate (%) measure is calculated by the division of two positive numbers ... Also, the Rate (%) measure divides by the number of hours in the month - based on the number of rows in the DimDate table (if that is helpful information ...)

 

Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    ah there was a filter on the line plot - i had copied it across from another report and did not think to check ... !

     

    thanks for the offers of help !

3 Replies

  • Tahreem24's avatar
    Tahreem24
    Super User
    6 years ago

    Anonymous ,


    COuld you please share your PBIX file by masking all confidential data. Or just put 2 columns values (Date and Rate% ) under the new PBIX ?

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    ah there was a filter on the line plot - i had copied it across from another report and did not think to check ... !

     

    thanks for the offers of help !