parameter selection is not passing values dynamically

[Anonymous]

Hi,

My requirement is to get the "no of days open" which is the date diff between the order date and the date that user passes in the report.

To do this, I have Order date already exist in my dataset values are from 1/1/2014 to 31/12/2018. I should have a date parameter that user can enter or select the date from parameter. for this I have created a parameter and pass the values from ship date (exist in data source values from 1/1/2014 to 31/03/2019 to parameter field (Period Close).

Now I have used order date in table that has all the dates and derived selected date field based on my parameter selection (period Close), then it should give diff between selected date in parameter and order date. it's working fine.

Now the challenge here is every time if i need to change my parameter I should go to edit queries and click on edit parameter that gives me list of values in paramter to choose. One way around that is also fine. but when I choose one of the date from paramter dropdown it asked to apply changes.

Even after I selected for apply changes selected date is not changed as per the parameter selection. it's still with the previous value. It didn't refresh until I manually refresh the parameter table.

this is the most basic requirement that users will expect in any reporting tool. the biggest disdvantage in power bi that I notice is that we can't place the parameter in report to pass the values. everytime we should got to edit queries and choose edit parameter to change the values.but still the selected value isn't updating in the report by default even after chosing apply changes option.

from the above graph I have choosed 21/04/2014 as default value in parameter so that it's shwoing 21/04/2014 in selected date, later I tried to change it to 31/12/2015 but it didn't. 

A quick help would be much appreciated.

Thanks 

Harsha

[rajecpl]

Hi 

Re: parameter passing from URL Servernane and dbname from power bi after publish to URL (fro changing the dataset)

i have created parameter with servername and dbname now i have published now as servname and dbname should be passed to URL can anybody help me out on this. 

[v-frfei-msft]

Hi @Anonymous ,

To filter the data dynamically, we can achieve that by a measure as below instead of parameter in power query.

Measure = 
VAR se =
    SELECTEDVALUE ( 'slicer'[Date] )
RETURN
    IF ( MAX ( 'Table'[date] ) <= se, 1, BLANK () )

[Anonymous]

Hi,

by mistake I checked accept button instead of reply. Please don't consider it as marked. Not sure how to unmark this as solution.

The solutions I am looking at is to get the date diff between the date and the selected date.but what yiou have sent me is different requirement.

Please see the below image,

from the above if you see I am getting blanck for date difference b/w the order date and date I am selected in. but I am expecting date diff b/w order date & selected date.

A quick help would be appreciated.