Line value not coming as expected

[YashikaAgrawal]

Line_issue

Hi,

This is line and clustered column chart, 2 issues please help

a. The blue line (line values) is not starting from the first chart (blue one)

b. The pink and blue bar need a gap.

Any suggestions would be appreciated.

Thanks,

[mussaenda]

Hi @YashikaAgrawal,

a. The blue line (line values) is not starting from the first chart (blue one)

It is normal that the line is not starting from the first bar if you mean bar and not chart, because it is a group so the line will start in the middle.

b. The pink and blue bar need a gap.

I don't get why you need a space between them but as I stated above, you are delaring it as a group that's why. If you need a gap between them or between pink and blue, you need to elaborate your x axis.

Hope this helps.

[YashikaAgrawal]

Thanks for the reply.

I have attached the expected report, please let me know what changes has be done.

ExpectedOne

[v-shex-msft]

HI @YashikaAgrawal,

You can write multiple measure formals with if statements to check current range and skip calculate on unmatched records, then you can use these measure formula on 'line value' field to achieve your requirement.

If you confused about coding formula, please share some dummy data with the expected results to test and coding formula.

Regard,

Xiaoxin Sheng

[YashikaAgrawal]

Thank you for the replies.

Attached the source data and the expected output, please let me know the formula to be used to get this, Thank you.

ExpectedReport

Excel could not attached here, below is the source data.

PropertyID	Year	Type	Description	Chart Value	Compset
11	2015	MPI	Message Passing Interface	117	85
11	2016	MPI	Message Passing Interface	117	86
11	2017	MPI	Message Passing Interface	131	70
11	2018	MPI	Message Passing Interface	124	81
11	2019	MPI	Message Passing Interface	139	72
11	2015	ARI	Agharkar Research Institute	94	106
11	2016	ARI	Agharkar Research Institute	88	114
11	2017	ARI	Agharkar Research Institute	97	103
11	2018	ARI	Agharkar Research Institute	98	103
11	2019	ARI	Agharkar Research Institute	90	111

[v-shex-msft]

HI @YashikaAgrawal,

Based on my test, I found line value will be forced summarize by axis and legend field not works to split these on line graph. I'd like to suggest you to use r visual to draw clustered column chart graph and split line graph at the same time.

Regards,

Xiaoxin Sheng

[mussaenda]

Create 3 separate charts to achieve your desired output.