cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pxg08680 Member
Member

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 values as

        -ProductLaunchRates

        -ProductEndRates

        -ProductEstimatedRates.

 

So when I select Option3 from the slicer, my table column name(column 4) should change to ProductEstimatedRates in place of ProductRates along with its respective values.

Default column name should be ProductRates.

 

is this possible, if yes how??"

 

 

Thank You

 

1 ACCEPTED SOLUTION

Accepted Solutions
pxg08680 Member
Member

Re: Table Column Header Changing based on Filter Selection

@v-yuezhe-msft

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

View solution in original post

5 REPLIES 5
Highlighted
nmck86 Member
Member

Re: Table Column Header Changing based on Filter Selection

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 Member
Member

Re: Table Column Header Changing based on Filter Selection

@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 Member
Member

Re: Table Column Header Changing based on Filter Selection

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

Moderator v-yuezhe-msft
Moderator

Re: Table Column Header Changing based on Filter Selection

@pxg08680,

We are not able to dynamically change column headers based on slicer selection.

There is a similar thread about this issue, please vote it up.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/20076022-can-i-make-column-header...

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
pxg08680 Member
Member

Re: Table Column Header Changing based on Filter Selection

@v-yuezhe-msft

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

View solution in original post

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 284 members 2,763 guests
Please welcome our newest community members: