Line and Clustered column chart - Need line for each cluster

[NSC7]

Hi All,

I need help with Line and Clustered Bar chart. Please let me know if it is possible to get line for each cluster like below.

Shared Axis - Location 

Column series- Month

Column Value  - Sum (Sales)

Line Values - Days 

Sample data-

Location	Month	Sales	Days
Loc 1	July	10	22
Loc 1	Aug	20	8
Loc 1	Sep	25	10
Loc 2	July	100	50
Loc 2	Aug	80	40
Loc 2	Sep	60	20
Loc 3	July	20	5
Loc 3	Aug	40	8
Loc 3	Sep	60	15

Thanks

[Anonymous]

Hi @NSC7 ,

Based on testing, I don't think it's possible to achieve this effect using line and clustered column charts.

Line y-axis groups summarize data according to X-axis, so the line on the graph has only three points, and we actually need it to group summarize data under Column Legend.

It would be nice to have the option to control under which field the line Y-axis summarizes the data.

You can submit this idea.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[NSC7]

@Greg_Deckler , I saw your reply on one of the similar kind of question.Please help if possible. I am not sure if this can even be done.

[NSC7]

I can also do one line like below

[Greg_Deckler]

@NSC7 This is what I could come up with after several failed attempts. Not exact but close. PBIX is attached below sig.