cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Route217
Responsive Resident
Responsive Resident

TRICKY - Bar Chart Plot for Current and Previous Year

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 

 

 

 

3 REPLIES 3
Eyelyn9
Community Support
Community Support

Hi @Route217 ,

 

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

 

 

 

Route217
Responsive Resident
Responsive Resident

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...

 

Route217
Responsive Resident
Responsive Resident

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 

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.