Solved: Visible filter criteria

Anonymous · ‎12-11-2020

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

Anonymous · ‎12-11-2020

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.

View solution in original post

Anonymous · ‎12-16-2020

Hi Buddy, could you mark this solution as accepted.

Anonymous · ‎12-11-2020

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.