Forum Discussion

mroomi's avatar
mroomi
Helper II
10 years ago
Solved

Add filter value into the report header

Hi, I'm trying to use the date filter in to report the report header, for example I have created a report on the fiscal year 2013-2014 but once I change the fiscal year to 2-14-2015 it should refres...
  • ankitpatira's avatar
    ankitpatira
    10 years ago

    mroomi Try this another approach. Download custom visual called Long Text Viewer from here. Drop same field in this visual as your report filter. Format it so that it looks like your report header. Then whenever a value is selected in your filter visual will also be filtered.

  • sornavoor's avatar
    sornavoor
    10 years ago

    mroomi, Example below  

     

    Measure Defined a below:

     

    Filtered Year = IF ( ISFILTERED(vw_Name[PSPStatus]), CONCATENATE("Document Count for the Fiscal Year ", (IF(HASONEVALUE(vw_Name[PSPStatus]), FIRSTNONBLANK(vw_Name[PSPStatus],"") ,""))), "Report Page is not Filtered by FY")

     

    Table Data:

    Table DataNo Values in Filter

     

    Noticed that Long Text Visual is unable to take Measure as an input ...

     

    Hope this helps! 

ankitpatira's avatar
ankitpatira
Community Champion
10 years ago

mroomi Try this another approach. Download custom visual called Long Text Viewer from here. Drop same field in this visual as your report filter. Format it so that it looks like your report header. Then whenever a value is selected in your filter visual will also be filtered.

mroomi's avatar
mroomi
Helper II
10 years ago

Hi ankitpatira,

Is there a way to use the long text visual with the teaxt header? Currently the long text visual is reading value from atextual field in database.

I'm trying to display the following text

 

"Document Count for the '2014-2015'" where 201-2015 value will be changed according to the filter. 

 

  • sornavoor's avatar
    sornavoor
    Resolver I
    10 years ago

    mroomi, Example below  

     

    Measure Defined a below:

     

    Filtered Year = IF ( ISFILTERED(vw_Name[PSPStatus]), CONCATENATE("Document Count for the Fiscal Year ", (IF(HASONEVALUE(vw_Name[PSPStatus]), FIRSTNONBLANK(vw_Name[PSPStatus],"") ,""))), "Report Page is not Filtered by FY")

     

    Table Data:

    Table DataNo Values in Filter

     

    Noticed that Long Text Visual is unable to take Measure as an input ...

     

    Hope this helps! 

    • mroomi's avatar
      mroomi
      Helper II
      10 years ago

      It, worked perfectly, really appreciate all of you guys help.