Forum Discussion
Visible filter criteria
Hi team,
In all of my created reports, filters are active. However, when the results appear according to the selected criteria, I would like these criteria to be mentioned in, for example, a sub-title of the report / diagram.
Example: filters are selected in Date from March 2020 to September 2020, client XXX
The subtitle could be titled: "title of the graph" + period + client
I hope I was clear enough and you can help me.
Rgds
Hi Anonymous - Use selectedvalue function to get the results, you could use the following:-
Selection = var dte = Min(Date)&"to"Max(Date) var client = selectedvalue(Client) var title = "Title" return title&"+"&dte&"+"&client
In this solution I am hoping that you have single client selection in the slicer, if its mutliptlt then me know, otheriwse if this solves your purpose kindly makr this solution as accepted.
2 Replies
Hi Anonymous - Use selectedvalue function to get the results, you could use the following:-
Selection = var dte = Min(Date)&"to"Max(Date) var client = selectedvalue(Client) var title = "Title" return title&"+"&dte&"+"&client
In this solution I am hoping that you have single client selection in the slicer, if its mutliptlt then me know, otheriwse if this solves your purpose kindly makr this solution as accepted.