TRICKY - Bar Chart Plot for Current and Previous Year

[Anonymous]

Hi Expert

See excel file. I want to plot the graph as per excel file - i have explained the data point in the excel file. The two bar charts represent Current and Previous Year based on the Metrics in Column A

In The Power bI File Ignore all the tables in the model other then - PL and Logistics and Dim Hierarchy. All the Data is in PL Table (FACT) table. 

I need to add Warehousing - Fixed and Variable and All freight data (Current Year) into one bar and Warehousing - Fixed and Variable and All freight data (BBP) Budget and plot the data over the months (periods) as shown in excel.

In The PL FACT Table

C_Year = Current Year

P_Year = Prior Year

C_Month = refers to 1+11 (1 month Actual + 11 months forecast)

Jan_CM_Fcst = Current Month

Jan_PM_Fcst = Previous Month

Jan_BBP = Budget Information

Excel File

https://www.dropbox.com/scl/fi/se7xjzk710jb257cmgjo0/Sample-Data_.xlsx?dl=0&rlkey=6rhj91bndh0ce5nhxl... 

PBIX File

https://www.dropbox.com/s/u5vfbu3a5j5mwwl/Logistics.pbix?dl=0 

[v-eqin-msft]

Hi @Anonymous ,

Sorry, It's a little hard for me to follow up the issue.

I cannot associate your key words with the table you provided...

Could you please simplify your pbix file and describe the requirements again in detail with the help of screenshots or the like?

Best Regards,
Eyelyn Qin

[Anonymous]

Hi Eyelyn

Apologies for the delay i have stripped out all the tables to simplify the model..

https://www.dropbox.com/s/u4cf5zwdj4cl4qv/Logistics_.pbix?dl=0 

Please refer to new measure in Logistics table and the issue now is that my graph is giving me constant values in the bar chart...

[Anonymous]

Hi Eyelyn

Here is my attempt at the formula but i am getting a constant line on the bar chart.... See new link..

https://www.dropbox.com/s/u4cf5zwdj4cl4qv/Logistics_.pbix?dl=0