Forum Discussion

joshua1990's avatar
joshua1990
Post Prodigy
6 years ago
Solved

Text output based on filter

Hello everyone! I have a title for one of our Reports that says something like: Overall Report I would like to add something like "Overal Report for this week" or Overall Report for this month" ba...
Need Help
  • TomMartens's avatar
    TomMartens
    6 years ago

    Hey joshua1990 ,

     

    I created this measure:

    ttl add selected filter to report = 
"The report title with selected filter value: "
 & IF(HASONEVALUE('DimDate'[CalendarMonthLabel]) , MAX('DimDate'[CalendarMonthLabel]) , "...")

    And then added it to the title of a txt box:

    I select the measure and the TXT-Box will look like this:

    Hopefully, this is what you are looking for.

     

    Regards,
    Tom

     

     

TomMartens's avatar
TomMartens
Super User
6 years ago

Hey joshua1990 ,

 

I created this measure:

ttl add selected filter to report = 
"The report title with selected filter value: "
 & IF(HASONEVALUE('DimDate'[CalendarMonthLabel]) , MAX('DimDate'[CalendarMonthLabel]) , "...")

And then added it to the title of a txt box:

I select the measure and the TXT-Box will look like this:

Hopefully, this is what you are looking for.

 

Regards,
Tom

 

 

  • Kenha09's avatar
    Kenha09
    Microsoft Employee
    3 years ago

    Hi, Tom!
    I'm very newbe here and have similar question. I want to have multiple filters that create a tittle, as the previous example. Lets say I select a region, a store, a vendor and a product. I want the output to be: "US, NY03, JohnSmith, sku111000"
    With the meassure you pasted could be possible? as 

    & IF(HASONEVALUE('Store'[StoreID], 'Employees' [vendor_name], 'Catalog' [SKU_number])

    or something like this?