create column chart with dynamic colum selection

[Nimmi]

Hi Team,

How to creat chart with actual amount and actual percent columns as below

X – Axis: Actual vs Planned, this talks about the difference between Planned budget and Actual budget

Y – Axis: No. of operations, this talks about number of operations in the data set

This KPI gives information on how many operations went under budget and how many went over.

Please help me on this chart creation.

[v-lili6-msft]

hi, @Nimmi

please share sample pbix file or some data sample and expected output . You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.

Best Regards,

Lin