Show Actual Values in Y-axis without any calculations

[archana_c]

hi
Suppose i have a sample data like below

My requirement is to create a chart based on this. X-axis should show the name column, Y-axis should show the days column(should show actual values like 30, 60, 90, 120 without any sum or count) and the data bars should be the values. When ever i take the days column it shows either count or sum. Is there any possible way to bring this chart?

NOTE: Corrected the question.
@Anonymous @v-yuta-msft 
@amitchandak @Greg_Deckler 

[qqqqqwwwweeerrr]

Hi @archana_c 

are you looing something like this

Regards

[archana_c]

No. I have corrected my question.

[Arul]

@archana_c , 

You need this on which chart? Also, can you confirm the X-axis values and the order?

Eg: A-30,B-30,C-30,D-30,A-60,.

[archana_c]

The chart would be Column chart. And x-axis should show the names, A,B,C,D

[Arul]

repition like A,B,C,D,A,B,C,D,A..., right?

[archana_c]

No. It cannot be repeated..It should be only once.

[Arul]

ok. then for A,B,C,D what is the value expected in the column chart?

[archana_c]

Hi, i just got the mistake from my end. The person A has done the payment in 30 days. B in 60 Days, C in 90 days and D in 90 Days. Means for each person there will only be one amount..that to paid in any of the number of days. Sample screenshot shared.

Expected chart:

[Arul]

@archana_c ,

Rename your columns like below,

select 30,60,90,120 column and select unpivot columns (refer the image),

change attribute column data type to whole number and also rename the attribute column to days (refer the image)

now close and apply, drag and drop the name and days column in the chart and apply value filter at visual level filter,

[archana_c]

Thanks for the reply. Let me know how you were able to drag the days to y axis without any aggregation like count or sum.

[Arul]

No as far as I know

[archana_c]

It shows 0, 50, 100 in the y axis. But when i drag the days column i get the count of days, which is wrong

Result:

[Arul]

Change the aggregation type to sum.

[archana_c]

its taking sum , but not the actual values.