Need help with one of the visual

[Oliya]

I have a requirement to plot a visual like below
In the x axix line of service is present and against each los cy and py value. Each CY and PY bar is stacked and also there will line graph. Could some one please help if this is possible to acheive in powerbi

[Oliya]

any wayout by merging the table?

[Oliya]

existing visuals

[Oliya]

Is there any way out to achieve this. They are very adamant with the requirement.

Clustered and stack chart together is achievable with the custom visual but I want to acheive this using 

[lbendlin]

They can be adamant all day long - still doesn't make it right. Push back hard. Make them understand why the line chart is the wrong choice.

[Oliya]

@lbendlin 

@amitchandak 
@Greg_Deckler

[Oliya]

let me know for further queries.

[lbendlin]

The average physiologial limit for dimensionality comprehension is 3.5 .  You are trying to cram six dimensions into a single chart, and you are trying to use a line chart where it should not be used (non-time-correlated data points).  Simplify your requirement, use different visuals.

[Oliya]

SAMPLE file attached : https://drive.google.com/file/d/1mJfpVne8KQqd2h-5vSXBwM0ShI3oHOii/view?usp=sharing

I want current year and previous year clustered bar stacked with differenect sources like grid diesel etc.
And also want line graph which will change dynamivally on the basis of current year and previous year.

final graph should be something like below:

 1. x - axis region with cy , py bars stacked with sources.
 2. y axis - electricty consumption.

 3.line graph : electricty consumption per sq ft.

[lbendlin]

Note:Using a line chart for unrelated categories is a UX red flag.

Anyway, Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523