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 refresh the report header instead of me or the user changing the report header or create a new report.

 

Thanks,

Roomi

  • 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! 

8 Replies

    • mroomi's avatar
      mroomi
      Helper II
      10 years ago

      Thanks,

      I tried to create a simple one but I get the following error

       

      Title = if (HASONEVALUE(vw_Name[PSPStatus]),vw_Name[PSPStatus])

       

      Error = "A single value for column 'PSPStatus' in table 'vw_Name' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result."

       

      Actually what I'm trying to do is to when ever the user changes the value of the filter it reflects in the report headrer.

       

      • sornavoor's avatar
        sornavoor
        Resolver I
        10 years ago

        Looks like you table vw_Name has multiple values  for  PSPStatus. 

         

        I am assuming that you have this a column as a single select filter.  

         

        You will have to consider situations for 

        Whether it is filtered  or not  ..using ISFILTERED

              If is not filtered, then you will have to handle the case by having  an appropriate text - can be blank too .

              If it is indeed filtered, then you check for HASONEVALUE(vw_Name[PSPStatus])  

                          The True part is easy  just display the first value.  

                          For the False part you may need to have some logic to eithe take min or max or first etc...

         

        Some thing like  below  and used the "Filtered Year" measure  in a card  visual and size it as needed 

         

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

  • mroomi's avatar
    mroomi
    Helper II
    10 years ago

    Thanks both of you, really appreciate your help. 

    This text visual really worked for my scenario.