cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
pundiv01 Helper I
Helper I

Filter is not applying in query string in power bi server

Hi,

 

I have a table and prepared a report in desktop and made a measure which calculate the URL based upon a ID dynamically.

This URL has [SIMPrjReqID] column as filter. When I publish this and try to see the filter report;It could not show me the filtered report
but only show me the original one which has all the data.in that way the filters are not applying by this URl.
The [SIMPrjReqID] is Text type.
May I seek for help.Please let me know for additional things you want to know about it.
 
4 REPLIES 4
Super User IV
Super User IV

Re: Filter is not applying in query string in power bi server

Can you post your DAX formula? What you posted doesn't look quite correct.


---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

pundiv01 Helper I
Helper I

Re: Filter is not applying in query string in power bi server

?filter=Append1/Append1[SIMPrjReqID] eq '&Append1[SIMPrjReqID]&'"

 

after report I am amending this formula in URL in order to create dynamic measure.

pundiv01 Helper I
Helper I

Re: Filter is not applying in query string in power bi server

this is the complete dax which i am using to create dynamic url (Append1 is table and [SIMPrjReqID] is column name.)
pundiv01 Helper I
Helper I

Re: Filter is not applying in query string in power bi server

The calculated URL is fine now but after publishing it is not giving me filter data.Could you please help.

I just went through a blog and when publishing through query string parameter it says that it has a limitation that it doesn't work when it will be published to web..what does it mean?

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.