chart with grouped data

[IF]

Hi,

I have the following data. I am using Name and Date columns at slicers. (the table looks stange, but should work with copy-paste).

NameStatusStatusKeyHoursDate

X	On time	2	1	12/2/2020
X	On time	2	2	12/2/2020
X	On time	2	-1	12/2/2020
X	On time	2	-2	12/2/2020
X	On time	2	0	12/2/2020
X	On time	2	3	12/2/2020
X	On time	2	3	12/2/2020
X	On time	2	3	12/2/2020
X	Late	3	1	12/2/2020
X	Late	3	2	12/2/2020
X	Late	3	3	12/2/2020
X	Late	3	8	12/2/2020
X	Late	3	10	12/2/2020
X	Early	1	-1	12/2/2020
X	Early	1	-2	12/2/2020
X	Early	1	-2	12/2/2020
X	Early	1	-14	12/2/2020
X	Early	1	-11	12/2/2020
Y	On time	2	0	12/2/2020
Y	On time	2	-1	12/2/2020
Y	On time	2	-3	12/2/2020
Y	On time	2	-1	12/2/2020
Y	On time	2	-2	12/2/2020
Y	On time	2	2	12/2/2020
Y	On time	2	3	12/2/2020
Y	On time	2	3	12/2/2020
Y	On time	2	3	12/2/2020
Y	Late	3	1	12/2/2020
Y	Late	3	2	12/2/2020
Y	Late	3	3	12/2/2020
Y	Late	3	8	12/2/2020
Y	Late	3	10	12/2/2020
Y	Early	1	-1	12/2/2020
Y	Early	1	-2	12/2/2020
Y	Early	1	-2	12/2/2020
Y	Early	1	-14	12/2/2020
Y	Early	1	-11	12/2/2020
Y	Late	3	3	12/2/2020

I want to use a chart that show the count of the value:

I made a column to show the count, but it sums and doesn't show with different colours.

HoursStatusDP = switch(true(),

'Table'[Hours] = 0 , "0 Hours",

'Table'[Hours] = 1, "+1 Hour",

'Table'[Hours] = 2, "+2 Hours",

'Table'[Hours] = 3, "+3 Hours",

'Table'[Hours] = 4, "+4 Hours",

'Table'[Hours] = 5, "+5 Hours",

'Table'[Hours] = 6, "+6 Hours",

'Table'[Hours] >= 7, ">=+7 Hours",

'Table'[Hours] = -1, "-1 Hour",

'Table'[Hours] = -2, "-2 Hours",

'Table'[Hours] = -3, "-3 Hours",

'Table'[Hours] = -4, "-4 Hours",

'Table'[Hours] = -5, "-5 Hours",

'Table'[Hours] = -6, "-6 Hours",

'Table'[Hours] <= -7, "<=-7 Hours",

"Unknown"

)

How can I show values with different colours? Green(on time) should always be at the bottom.

The file is also available at: https://gofile.io/d/56DLU1

All the best,

[IF]

Hi, Thanks for the reply. However, I want to group the data in some bars. -2 days, -1day, 1day, 2days and 3 days bars have two different type of data. For example; Name X: -2 days/hours is 3 in total. However, 2 of 3 is for early and 1 is for on time. Similarly, 3 days/hours is in total 4. However, 3 of 4 is on time and 1 of 4 is late. Early should be yellow, ontime is green and late is red. As you see at the post, these bars have two different colours. I want to do it in this way. If I change as you mentioned, it changes the whole bar.

All the best

[gpiero]

@IF

Something like this, right?

And for each bar you would like to displaly X + Y, right? (now you can see only X)

[gpiero · Accepted solution]

@IF 

Please check if what you will find at pag 4 could help you. 

https://1drv.ms/u/s!Ah7_1Sua__g-60KSBWTyNS_d1Udf?e=j7mZSw 

Regards

[IF]

It is exactly what I wanted. Thanks a looot!

[gpiero]

@IF

Hi

You could use the option for Data colors to have different colors

Regards