cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Route217
Post Prodigy
Post Prodigy

Getting Constant Bar

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 

1 ACCEPTED SOLUTION
Route217
Post Prodigy
Post Prodigy

Hi 

 

I have simplified the model, i hope this help. Apologies for teh delay

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

View solution in original post

4 REPLIES 4
v-yangliu-msft
Community Support
Community Support

Hi  @Route217  ,

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.

v-yangliu-msft
Community Support
Community Support

Hi  @Route217  ,

 

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

Route217
Post Prodigy
Post Prodigy

Hi 

 

I have simplified the model, i hope this help. Apologies for teh delay

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

View solution in original post

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

April Update

Check it Out!

Click here to read more about the April 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.