#powerbi #powerbi_training #powerbideveloper #powerbipro #powerbiservice #powerbidashboard #powerbitraining

Raw files are available in my LinkedIn Profile Projects Section: [ Ссылка ]

#power bi project #power bi projects for practice #power bi Gantt chart
#power bi Jira
#gantt chart in power bi
#power bi project management
#power bi sample projects for practice
#power bi projects kaggle
#power bi for project management

1) Filter a report using query string parameters in the URL
When you open a report in Power BI service, each page of the report has its own unique URL. To filter that report page, you could use the Filters pane on the report canvas. Or you could add query string parameters to the URL to pre-filter the report. Perhaps you have a report you'd like to show colleagues and you want to pre-filter it for them. 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.

This article uses the Retail Analysis Sample report. If you want to follow along, you can download the sample report.


1)Uses for query string parameters
Say you're working in Power BI Desktop. You want to create a report that has links to other Power BI reports, but you want to show only some of the information in the other reports. First, filter the reports using query string parameters and save the URLs. Next, create a table in Desktop with these new report URLs. Then publish and share the report.

Another use for query string parameters is for someone creating an advanced Power BI solution. Using DAX, they create a report that generates a filtered report URL dynamically based on the selection their customer makes in the current report. When customers select the URL, they see only the intended information.

2)Query string parameter syntax for filtering
With parameters, you can filter the report for one or more values, even if those values contain spaces or special characters. The basic syntax is fairly straightforward; start with the report URL, add a question mark, and then add your filter syntax.

URL?filter=Table/Field eq 'value'




Table and Field names are case-sensitive, value isn't.
Fields that are hidden from report view can still be filtered.
Field types
Field type can be a number, datetime, or string and the type used must match the type set in the dataset. For example, specifying a table column of type "string" won't work if you're looking for a datetime or numeric value in a dataset column set as a date, such as Table/StringColumn eq 1.

Strings must be enclosed with single quotes, as in 'manager name'.
Numbers require no special formatting. See Numeric data types in this article for details.
Dates and times See Date data types in this article.
If it's still confusing, continue reading and we'll break it down.


Other videos:
1) Power BI Real Time Project || Freelancing project worth $100: [ Ссылка ]
2)Power BI Complete Realtime Project ( Finance Analysis ) #powerbi [Hindi] || Project From Freelancing
[ Ссылка ]

свернуть