Forum Discussion

pxg08680's avatar
pxg08680
Resolver III
8 years ago
Solved

Table Column Header Changing based on Filter Selection

Hi Everyone,   I need an immediate solution or work around for this- " I have table with 6 columns and one of the column name(say column 4) is ProductRates. I have a Slicer on my report with valu...
Need Help
Show and Tell
  • pxg08680's avatar
    pxg08680
    8 years ago

    Anonymous

    Thank you for the reply.

     

    Right now I am using the solution of nmck86 and card visual as awork around.

    But this issue needs to resolved in a proper way in future.

     

    Thank You

nmck86's avatar
nmck86
Post Patron
8 years ago

you may be looking for something similar to below

 

Fact Sheet Title = IF(HASONEVALUE('table', [field name]), "Text that I wanted to appear" & VALUES('table', [field name]) & " More text I want to see" &", "& VALUES('table', [field name]), IF(HASONEVALUE('table', [field name]), "moretext"& VALUES('table', [field name]), "more free text"))

 

a good video to reference is below:

https://www.youtube.com/watch?v=wYgjaI35rg8 

pxg08680's avatar
pxg08680
Resolver III
8 years ago

nmck86

 

What you shared is working fine but thing is how do I use it as Column Header...?

 

Your solutions takes the selection from slicer and concatinates text and displays what I needed. But can you tell me how to use this new measure as a table column header..

 

 

Thank You

  • pxg08680's avatar
    pxg08680
    Resolver III
    8 years ago

    Can someone provide an update on this..??

    All I need is in a Table visual, column header needs to be changed according to the selection made in the slicer/filter.

     

    Any help is appreciated.

     

     

    Thank You