Forum Discussion

bendodson's avatar
bendodson
New Member
3 years ago

Missing categories in chart

Hi there,

 

I am trying to create a graph showing the sum of one column ('Duration) by another column made up of several categories ('Type').

 

However, for some reason only two categories of the 'Type' column are showing up when a create a table or graph to display this sum, namely 'Leave' and 'Normal Time'. In the 'Type' column, there are several other categories that are not showing up including 'Call Out/On Break', 'Travel' and 'Overtime'. 

 

You can see what I mean in the following picture, where the categories 'Call Out/On Break' and 'Travel' are not displayed in the chart.

 

 

 

 

 

 

I would like to know how to get these missing categories to appear in the graph and understand why they are not showing up in the first place when I don't have any filters enabled that I'm aware of.

(Link to download my .pbix file for context)

 

Many thanks,

Ben

 

 

2 Replies

    • bendodson's avatar
      bendodson
      New Member

      Hi Mahesh,

       

      Unfortunately I get the same result when using your solution of creating a measure 'Total Duration':