Forum Discussion
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.
URL = "https://app.powerbi.com/groups/ce347380-637d-4700-838f-f7b00294256c/reports/374c3b7b-18f0-46f6-b5ec-2c97cbb01611/ReportSection?filter=Append1/Append1[SIMPrjReqID] eq '&Append1[SIMPrjReqID]&'"
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
Can you post your DAX formula? What you posted doesn't look quite correct.
- "https://app.powerbi.com/groups/ce347380-637d-4700-838f-f7b00294256c/reports/374c3b7b-18f0-46f6-b5ec-2c97cbb01611/ReportSection?filter=Append1/Append1[SIMPrjReqID] eq '&Append1[SIMPrjReqID]&'"this is the complete dax which i am using to create dynamic url (Append1 is table and [SIMPrjReqID] is column name.)
