Sometimes you want the report to display all the pamameters that are applied, especially when the parameter section is hided. To do that, you can simply use a text box and and point the value to the parameters. However, to display all members of a multiple value parameter, you will need to use the JOIN() function.
For example, if you have a parameter called Area that filters work items by the Area field, the following expression will allow you to display all the selected areas on the report.
="Area: " + JOIN(Parameters!Area.Label, ", ")
Thanks to a post I found on bokebb.com. Here is the link to it:
http://www.bokebb.com/dev/english/2008/posts/2008112686.shtml
Connecting Power BI Semantic Models To Data Sources Automatically With
Binding Hints
-
Did you know that you can configure your Power BI semantic model so that it
automatically binds to a data source connection when you publish? To
illustrate...
3 weeks ago
No comments:
Post a Comment