Power BI just got even more powerful with recent updates to report URL filters. These enhancements not only expand the operators and data types you can pass as filters but also enable you to use a measure as a web URL, allowing for dynamic hyperlinks at the page level.
In this post, we’ll break down the new features step by step and show you how to implement them in your reports.
What’s New in Power BI Report URL Filters?
Power BI URL filters have been around for a while, but they were limited in functionality. With the recent update, you can now:
Use additional operators such as greater than, less than, greater than or equal to, not equal to, and in.
Pass integers and dates as filter values, not just text.
Handle special characters in table and column names using Unicode formatting.
These improvements give you much more flexibility when building dynamic, interactive navigation in your Power BI reports.
Why Use a Measure as a Web URL?
Previously, adding hyperlinks at the row level in a table was easy. But what if you want a single hyperlink that applies to the entire page context?
With the update, you can categorize a DAX measure as a web URL. This lets you dynamically generate a URL — including query string filters — based on slicer or page context, and display it as a clickable hyperlink.
Step-by-Step: Build Dynamic Report Links
Here’s how you can put all these new features to work:
Publish Your Target Report
First, make sure the report you want to link to is published to a workspace (not My Workspace). This ensures the URL is persistent and accessible to others.
Construct the Base URL and Query String
Start by getting the base URL of your target report. Then build a query string using this pattern:
?filter=Table/Column eq 'Value'
For example:
?filter=District/DistrictID eq 9
In your DAX measure, you can use SELECTEDVALUE() to retrieve the current filter context dynamically.
Example DAX:
ReportLink =
"https://app.powerbi.com/groups/your-workspace/reports/your-report-id" &
"?filter=District/DistrictID eq '" & SELECTEDVALUE(District[DistrictID], MIN(District[DistrictID])) & "'"
Categorize the Measure as a Web URL
In Power BI Desktop:
- Select your measure in the Fields pane.
- Go to the Modeling tab.
- In the Properties section, set Data Category to
Web URL.
Now, Power BI will render the measure as a clickable link in your visuals.
Display the Link or Use a URL Icon
When you add the measure to a table or matrix, Power BI can display it either as full text or as a URL icon. Use the visual formatting options to choose your preferred style.
Advanced Features You Can Use
Use in Operator:
You can pass multiple values to a filter using the in operator and a comma-separated list. Build this list dynamically in DAX with CONCATENATEX().
Pass Dates:
You can now pass dates in YYYY-MM-DD format. Make sure to use the correct date format for your locale.
Handle Special Characters:
For column names with spaces or special characters, replace spaces with Unicode (e.g., space is _x0020_) wrapped with underscores:
Table/_x0020_Column eq 'Value'
New Operators Supported:
eq(equals)ne(not equal)gt(greater than)lt(less than)ge(greater than or equal to)le(less than or equal to)
Why These Features Matter
These enhancements unlock powerful scenarios for dynamic navigation and interactive dashboards. Report users can now jump to pre-filtered reports directly from your visuals, improving user experience and reducing the need for manual filtering.
Final Thoughts
The updated Power BI report URL filters and the ability to use a measure as a hyperlink open up exciting possibilities for creating more interactive, user-friendly reports.
Whether you need to pass multiple filters, include dates, or handle special characters, Power BI now has you covered.
Start experimenting with these features today to make your reports even more dynamic and actionable.
Learn More About Power BI
Looking to sharpen your Power BI skills and create advanced, professional-grade reports?
Explore Power BI Training for expert-led courses and resources.
