Plan Vs LE/Actual

[CMA Suresh]

Dear All,

Can anyone help me in the Plan Vs LE(Actual) representation in the Power BI, i had kept screen shot for your reference,
Query : when i am selecting the slicer of Q-1 in Plan and LE, i am getting result 2 in the both columns, but original plan was 4 and LE was 2,
How to prepare this Plan Vs LE Visualisation in Power BI
I had attached the excel as well

Regards,
Suresh

 

[Chihiro]

You need to flatten data. Meaning Qtr data should be single column and another column for LE/Plan.

 

[CMA Suresh]

You need to flatten data. Meaning Qtr data should be single column and another column for LE/Plan.

ok, But master data is like excel i shared, can you provide the solution in Power BI

 

[Chihiro]

Load data to PQ. Then in the editor, select Plan Qtr & LE Qtr. Then unpivot.

Load data to data model and make pivot table using data model as source.

That's pretty much it.

 

[CMA Suresh]

Load data to PQ. Then in the editor, select Plan Qtr & LE Qtr. Then unpivot.

Load data to data model and make pivot table using data model as source.

That's pretty much it.

Thank you,
Suresh