Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi Experts
Ref only to PL Table and Logistics Table and Measures __v_Act2021 and Graph - WD + Freight.
I want to be able to plot all the months in the Year Based on the Selected Period Slicer (so if the user selects 1+11 i.e. plot 1 month Actual and 11 forecated) and Ignore the Selected Month Slicer.
My issues is do not now how to amend the measure __v_Act2021 so i get the correct sum values for each of the months...
https://www.dropbox.com/s/u4cf5zwdj4cl4qv/Logistics_.pbix?dl=0
Solved! Go to Solution.
Hi
I have simplified the model, i hope this help. Apologies for teh delay
https://www.dropbox.com/s/u4cf5zwdj4cl4qv/Logistics_.pbix?dl=0
Hi @Anonymous ,
Glad to hear that you have solved this problem by yourself. Would you like to mark your own reply as a solution so that others can learn from this too?
Thank you very much!
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
Excuse me, if the user selects 1+11, the value of January and the total value of February to December will be displayed. If the user selects 2+10 first, the total value of January to February and the total value of March to December will be displayed.
Is this your expected result?
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Liu Yang - i have resolved the issues. Thanks for all your assistance in looking at question i;ll post soultion here.
thanks once again
Hi
I have simplified the model, i hope this help. Apologies for teh delay
https://www.dropbox.com/s/u4cf5zwdj4cl4qv/Logistics_.pbix?dl=0
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
142 | |
75 | |
64 | |
52 | |
47 |
User | Count |
---|---|
219 | |
89 | |
73 | |
66 | |
60 |