Forum Discussion

PoovigaS's avatar
PoovigaS
Regular Visitor
11 months ago
Solved

Regarding URL filters

Hi, I’m working on filtering a report (embeded report) by passing tableName, columnName, and values in URL and setting filters when rendering the report. The filter works fine for most column...
Need Help
Show and Tell
PoovigaS's avatar
PoovigaS
Regular Visitor
11 months ago

I'm embedding a Power BI report in a custom application and applying filters via URL parameters — not using the  ?filter query string directly. I parse the parameters and apply filters during report rendering using the Power BI JavaScript API.

Filtering works fine for text columns, but I'm having trouble applying filters to date columns. Here's what I've tried:

 

  • Is there a specific format expected for date values in embedded filters?
  • Does Power BI apply any internal transformation (e.g., rounding or averaging) for date picker columns?Are there known issues with filtering on Date/Time columns using IAdvancedFilter?

Any insights or suggestions would be greatly appreciated!


What' not working:
1) ?table=Agent Status&column=Agent Date&values=2025-09-02,2025-09-06&type=date-range
2) ?table=Agent Status&column=Agent Date&values=datetime'2025-09-02T00:00:00',datetime'2025-09-06T00:00:00'&type=date-range

What's working:
?table=Agent Status&column=Agent Name&values=CSR - Ashamad

 

Anonymous's avatar
Anonymous
Not applicable
11 months ago

Hi  PoovigaS ,

 

Based on the information, it appears you are utilizing a date range slicer along with a measure to count records within the selected date range. The card visual is returning a count of 3, which indicates that your DAX measure is functioning correctly and the model is filtering data according to the slicer selection.

If your measure is similar to:

CountWithinRange = COUNTROWS(YourTable)

or uses CALCULATE, it should be capturing the slicer context appropriately. In Power BI, applying a date column to a slicer will filter visuals using that field automatically, unless the filter context is explicitly removed.

If you are implementing more advanced logic, such as comparing two date fields or requiring dynamic date filtering, please share the specific DAX formula you are using. This will allow us to review and suggest any necessary improvements.

Please let me know if you encounter any discrepancies in the counts or if the measure does not respond as expected to slicer changes. I am available to assist further.

 

Please find the attached PBIX and Screenshort file for your reference.

 

Best Regards,

Tejaswi.

Community Support



 

  • Anonymous's avatar
    Anonymous
    Not applicable
    11 months ago

    Hi PoovigaS ,

     

    I wanted to follow up and see if you had a chance to review the information shared. If you have any further questions or need additional assistance, feel free to reach out.

     

    Thank you,

    Tejaswi.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      11 months ago

      Hi  PoovigaS ,

       

      Just checking in have you been able to resolve this issue? If so, it would be greatly appreciated if you could mark the most helpful reply accordingly. This helps other community members quickly find relevant solutions.

       

      Thank you.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        11 months ago

        Hi PoovigaS ,

         

        I hope the information provided has been useful. Please let me know if you need further clarification or would like to continue the discussion.

         

        Thank you,

        Tejaswi.