Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
abhiram342
Employee
Employee

Measure to display query string parameter from report url

Hi all - We have created report based on dynamic m paramters using direct query. We want to pass query string paramter from report url and assign the value to dynamic m parameter. Currenlty, the functionality Works fine but only issue is we want to know what's parameter value being passed in the url . I created measure but it's not working fine. Can you please help.

Example:

Model:

abhiram342_0-1708984401157.png

Result by passing below parameter to report (filter=ProductSearch/ProductIdFilter eq 'Job6789_8d02ac83dfd6')

functionality works fine but Selected Value is displaying Blank

SelectedValue = SELECTEDVALUE('ProductSearch'[ProductIdFilter])

 

 

 

abhiram342_1-1708984526315.png

 

Thanks,

Abhiram

 

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

needs to be a column and that column needs to be bound to the dynamic M parameter.

View solution in original post

2 REPLIES 2
lbendlin
Super User
Super User

needs to be a column and that column needs to be bound to the dynamic M parameter.

Thanks @lbendlin ! Our dataset size is big hence using this approach.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.