| Excerpt | ||
|---|---|---|
| ||
configure your PowerBI application ID |
...
Projector can dynamically filter displayed content. For example, you might have a dashboard report that shows holidays balances profit for all your resources. But when displayed on My Home Page you only want to display data about the current resource. This is where filters come in. projects. When you display that project you want your PowerBI to automatically filter the displayed data to just that project. This keeps you from having to build a separate report for each project. You can build one report for all projects and filter as appropriate.
Filter Locations
Hard-Coded Filters
Combination Filters
Dynamic Filters
The filters available depend on where you are displaying content. To see the available filters see:
- My Home Page -User Types Editor - Dashboards Tab
- Performance Dashboards
- Project Workspaces -Project - Project Workspaces
Escaping Special Characters
| Warning | ||
|---|---|---|
| ||
If your field name contains spaces or non-ASCII characters they either need to be renamed or they need to be escaped. The most frequent character you'll see that needs escaping is a space. To escape a character:
For example, a space becomes _x0020_. The field 'Project Code' would become 'Project_x0020_Code'. |
Filter Example
Example syntax for various filters
| Code Block |
|---|
//Basic filter constructor
[DataSetName]/[Field Name] eq '[Field Value]'
//Example of hard-coded filter
MyGinsuReport/ProjectCode eq 'P001023-001'
//Example of dynamic filter
MyGinsuReport/ProjectCode eq '{0}' //the {0} is automatically replaced based on the project you are viewing
//Example of dynamic filter on two fields
MyGinsuReport/ProjectCode eq '{0}' & ClientName eq '{7}'
//Example of escaping a the space character in 'Project Code' (see https://docs.microsoft.com/en-us/power-bi/service-url-filters#special-characters-in-url-filters)
MyGinsuReport/Project_x0020_Code eq 'P001023-001'
|