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
Power BI Copilot, AI Instructions And DAX Query Templates
-
At the end of my last post I showed how, if you put the definition of a
measure in the AI Instructions of your Power BI semantic model, Copilot can
use it ...
1 day ago
No comments:
Post a Comment