Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
PBIX File
https://www.dropbox.com/s/u5vfbu3a5j5mwwl/Logistics.pbix?dl=0
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
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...
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
118 | |
107 | |
70 | |
70 | |
43 |
User | Count |
---|---|
148 | |
104 | |
104 | |
89 | |
66 |