cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Dubfelix
Frequent Visitor

What if parameter where the user selects different periods with different values

What if parameter working for total period like 40% reduction from July 2020 to July 2021 . 

I have being asked that the users can pick the period like July 2020 = 40% reduction August 2020 is 50% reduction Sept 2020 =75%.  Then the next user using the report put in different % reductions per month.  I have created a spreadsheet where the user updates but its not a great user experience. 

 

Can the user pick the full year and enter the % reduction per month like a drop down menu.  

 

Thanks All

 

4 REPLIES 4
v-xicai
Community Support
Community Support

Hi @Dubfelix ,

 

>>Can the user pick the full year and enter the % reduction per month like a drop down menu.  

 

What if parameter can only be showed like format below instead of Dropdown menu. As a workaround, you may create a Year slicer visual, and then takes effect with the what if parameter slicer.

126.png

 

 

 

 

 

 

 

 

 

 

You can learn more:https://docs.microsoft.com/en-us/power-bi/desktop-what-if.

 

Best Regards,

Amy 

 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Dubfelix
Frequent Visitor

Thanks @v-xicai I have a Year Month Slicer in the PBX file and it works great for 1 parameter like your screenshot below.  But with Covid, buisiness are predicted to come back to full usage over time. The users have asked for different % values per month over the next 12 months.  I am working with the excel updating the parameter at the moment.

v-xicai
Community Support
Community Support

Hi @Dubfelix ,

 

The what if parameter may not help your issue, since it can't change according to your Year Month slicer. You may need to add every percent matched to the Year Month into your formulas of calculated column or measure.

 

Best Regards,

Amy 

 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak
Super User IV
Super User IV

@Dubfelix , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

 

We can try something like

measure =
var _max1 = maxx(allselected(Date),Date[Date])
var _max = eomonth(_max1,1)
var _min = eomonth(_max1,0)
return
calculate(sum(Table[Data])*.4, filter(all(Date),Date[Date]>=_max && Date[Date]<=_min))



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

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.