Using the same example, to filter the report to show data only for stores in "NC" (North Carolina) or "TN" (Tennessee), append the URL with the following ?filter=Store/Territory in ('NC', 'TN') URL?filter= Table/ Field in (' value1', ' value2') To filter on more than one value in a single field, you use the in operator instead of the and operator. Our report is now filtered for North Carolina all the visualizations in the report show data for only North Carolina. So to filter the report to show data only for stores in "NC", we append this string to the URL: ?filter=Store/Territory eq 'NC' NC is the value that represents North Carolina in the Territory field of the Store table. Let’s assume that the URL to our report is the following.Īnd we see in our map visualization above that we have stores in North Carolina. If it's still confusing, continue reading and we'll break it down.
If you want to follow along, you can download the sample report. This article uses the Retail Analysis Sample report. One way to filter it is to start with the default URL for the report, add the filter parameters to the URL, and then email them the entire new URL. Perhaps you have a report you'd like to show colleagues and you want to pre-filter it for them. Or you could add query string parameters to the URL to pre-filter the report. To filter that report page, you could use the Filters pane on the report canvas. When you open a report in Power BI service, each page of the report has its own unique URL.