Forum Discussion

mike_s's avatar
mike_s
Regular Visitor
8 years ago

Values in chart all the same

Hi,

 

Hoping someone can help as my knowledge is pretty basic at the moment. Basically i'm trying to determine number of incidents by location or by status, for example.

 

The table i need to get the info from looks like the below - in this case "list_name" is filtered by status:

 

 

In the same table "list name" also has corresponding entries for "location"- as shown below:

 

 

The issue i have is when i create a chart to view number of incidents by location or by status, the total value is always the same  for each bar or column- instead of getting a breakdown. I'm not 100% this is the reason but suspect because there are duplicate entries in the "value_key" column. See example below:

 

 

The table is from a SysAid SQL DB.

 

Any help would be really appreciated

 

thanks

 

 

 

 

 

 

 

 

 

 

 

 

Need Help

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Mike_S

     

    I presume the columns are in two separate tables? If so, then all you need to do is go to "Manage Relationships", ensure the relationship between the two tables is active and, more specifically, ensure "Both" directions is selected.

     

    That should do the trick.

    • _vb_'s avatar
      _vb_
      Regular Visitor
      2 years ago

      It did the trick. Starting with Power BI - Appreciate 

  • v-danhe-msft's avatar
    v-danhe-msft
    Microsoft Employee
    8 years ago

    Hi mike_s,

    From the screenshot, the “Count of id” is in Value bucket. I would like to know if the “Count of id” means the id column set with Count aggregation, or it’s a measure name. If it’s the former, please share corresponding id values for each value_caption. If it’s the later, please share the DAX of this measure.

     

    To find the cause as soon as possible, I would suggest you share pbix file if possible. If the report does contain sensitive data, please upload your report to your OneDrive and send the link to me via private message.

     

    Regards,

    Daniel He

    • mike_s's avatar
      mike_s
      Regular Visitor
      8 years ago

      Hi v-danhe-msft,

       

      "Count of ID" is set with count - i havent created a measure that i am aware of- see screenshot below. I also wanted to point out that if i query values in other tables it counts ID quantity fine. It's just from this one particular table (In which "list_name" is) where i need to reference multiple entries within the same column (location, status etc):

       

       

      does that help?

       

      Thanks

       

  • Ritsgorge6's avatar
    Ritsgorge6
    New Member
    3 years ago

    I'm currently experiencing this same issue. Tha bars in the image is supposed to show me how many sellers are in each rating.

     

    I'm trying to see review score against count of sellers