Bar Chart based on the two dimensions and one measure

[anshenterprice]

Hi Team
Source Data

Date	Scriptname	buy/sale	Quantity
5/6/2022	TataMotos	buy	50
5/6/2022	Relience	sale	-150
5/6/2022	HIU	buy	50
5/6/2022	Titan	buy	50
5/12/2022	TataMotos	buy	100
5/12/2022	Relience	sale	-50
5/12/2022	HIU	buy	50
5/12/2022	Titan	sale	-50
5/12/2022	Info	Sale	-50

Note: whatever buy quantiy it always sale same quantity then sum will become be 0 for a date
Output:
Xaxis is the date and each script name in the BAr graph with the QuantiTY

[v-henryk-mstf · Accepted solution]

Hi @anshenterprice ,

Add the corresponding fields directly to the clustered column chart, or create a simple measure formula that will automatically group fields based on the fields in the legend:

Measure = sum('Table'[Quantity])

If the problem is still not resolved, please point it out. Looking forward to your reply.

Best Regards,
Henry

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

[jaipal]

@anshenterprice please download the file here