cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
X19203659
Frequent Visitor

Power bi report builder setup parameter to avoid the parameter to revert back to default value

Hi experts,

 

I hope that you are keeping well

 

On the app powerbi I have published some reports with 3 parameter (routes, start and end date). These report were built via Power Bi Report Builder.

When I open the reports for the first time, the reports run normally filtered by the default value located in the parameter.

default dates

X19203659_0-1674218406066.png

 

 Then I am not able to amend the "to calendar date" parameter and then the "from calendar date" parameter without having the "to calendar date" reset to the default value.

non default value for "to calendar date"

X19203659_1-1674218710056.png

 

Try now to amend the "from calendar date" without having the "to calendar date" reverting to 21/01/2023 (it is impossible)

X19203659_2-1674218858559.png

The only way to amend the two date parameters from the default value is first to amend the "from calendar date" parameter and then the "to calendar date" parameter.

The 2 date parameters  revert to their default values when I also amend the "routes" parameter. 

 

Does a solution exists to amend parameters without being obliged to amend them in a certain order to avoid the risk of having a default value reappering? 

 

Many thanks in advance for your help!

 

Kind regards,

 

Guillaume

 

 

0 REPLIES 0

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

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

Top Solution Authors