Forum Discussion

mvgust's avatar
mvgust
Helper III
5 years ago
Solved

Set Page title based upon Page Filter

I need to set a page title for my report based upon the page filter.  This report is always going to display the last full calendar week, how would I set the page title to "Report from Sept 6, 2020 t...
Need Help
  • dedelman_clng's avatar
    dedelman_clng
    5 years ago

    Hi mvgust  - sorry I didn't check my code. Try this

     

    Pg Title = 
var __FromDt = FORMAT( MINX( ALLSELECTED( DateTab[Date] ), DateTab[Date] ), "MMM DD, YYYY")
var __ToDt = FORMAT( MAXX( ALLSELECTED( DateTab[Date] ), DateTab[Date] ), "MMM DD, YYYY")
RETURN
"Report from " & __FromDt & " to " & __ToDt

     

    Page (and report filters for that matter) should be able to be accessed like any other type of filter.

     

    Hope this helps

    David

mvgust's avatar
mvgust
Helper III
5 years ago

That doesn't seem to work: 

 

"The MIN function only accepts a column reference as an argument"

 

Also, I'm not using a slicer, I'm using the page filter functionality.  I know you can pass slicer selections but my primary issue is passing PAGE filters. I'm not finding a formula to do so?

dedelman_clng's avatar
dedelman_clng
Community Champion
5 years ago

Hi mvgust  - sorry I didn't check my code. Try this

 

Pg Title = 
var __FromDt = FORMAT( MINX( ALLSELECTED( DateTab[Date] ), DateTab[Date] ), "MMM DD, YYYY")
var __ToDt = FORMAT( MAXX( ALLSELECTED( DateTab[Date] ), DateTab[Date] ), "MMM DD, YYYY")
RETURN
"Report from " & __FromDt & " to " & __ToDt

 

Page (and report filters for that matter) should be able to be accessed like any other type of filter.

 

Hope this helps

David

  • mvgust's avatar
    mvgust
    Helper III
    5 years ago

    Thanks David!  I was able to implement successfully.  This also helps with my general knowledge knowing ALLSELECTED will allow me to use those page filters elsewhere.