Difference between PY and CY in Bar Chart

[Optimusprime_25]

Hi team,

We have a requirement where we have to display difference between PY and CY bars as data label in a bar chart. We are stuck at this point. If anyone have any points please let me know.

I have created below chart, unable to proceed further.

Thanks in advance.

[Anonymous · Accepted solution]

Hi @Optimusprime_25 ,

I have created a simple sample, please refer to my pbix file to see if it helps you.

Create a measure to calculate the difference.

Measure = VAR _1=SUMX(FILTER(ALL('Table'),'Table'[subject]="CY"&&'Table'[date]=SELECTEDVALUE('Table'[date])),'Table'[VALUE])
VAR _PY=SUMX(FILTER(ALL('Table'),'Table'[subject]="PY"&&'Table'[date]=SELECTEDVALUE('Table'[date])),'Table'[VALUE])
RETURN
_PY-_1

Then choose the Line and clustered column chart.

Put the measure to the Line y-axis.

Next select Format your visual>>Data label>>Series.

Finally adjust the stroke width to 0 px.

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Optimusprime_25]

Thanks @Anonymous  for your prompt response.

It has  worked, we have done few modifications from our end.