Forum Discussion

mvgust's avatar
mvgust
Icon for Helper III rankHelper III
6 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
    6 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

dedelman_clng's avatar
dedelman_clng
Icon for Community Champion rankCommunity Champion
6 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
Icon for Helper III rankHelper III
6 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.