Forum Discussion

jongee's avatar
jongee
Frequent Visitor
9 years ago
Solved

Values different when entered in Line & Cluster Column Chart

Hi All

 

I have created two separate Cluster charts in Power BI desktop and they work great.

 

 

If I try and move the bottom chart into my top Line & Cluster Column Chart the data appears to display the same value for each month. (Yellow line).

 

 

Both the date fields are returning a date format of 'DD/MM/YYYY' and are set as a date field in PowerBI. 


The data is being pulled in from a ODBC connection.

 

Any help would be great.

Need Help
Show and Tell
  • jongee's avatar
    jongee
    9 years ago

    Thanks for the response. I have not managed to correct the issue yet, but I did completely forgot about setting the relationship.

     

    I have two tables one showing items that have been processed and the second showing new items that have been created (not all created items are processed). 

     

    So I want the line to show the number of items created and the columns show the number of items processed.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    How many dimensions / tables do you have?

    Is part number a measure or columns?

     

    Sometimes I switch the chart into Table View to check my raw data, maybe if they are from different tables, relationship might not be right / created?

     

    Might be useful to see the diagram view of your data?

    • jongee's avatar
      jongee
      Frequent Visitor
      9 years ago

      Thanks for the response. I have not managed to correct the issue yet, but I did completely forgot about setting the relationship.

       

      I have two tables one showing items that have been processed and the second showing new items that have been created (not all created items are processed). 

       

      So I want the line to show the number of items created and the columns show the number of items processed.