Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

We've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now

Reply
vjnvinod
Impactful Individual
Impactful Individual

Dynamic headers measure help

Hi,

 

i am currently using  the below measure,  but it can only take one coloumn, is there any other function i can use for multiple coloumns?

so that when i select any of my coloumns value(Text), it  can dynamically change my headers?

 

SectorSd = SELECTEDVALUE(Inbound[AccountSector],"TMT")
5 REPLIES 5
Greg_Deckler
Community Champion
Community Champion

There are measures like ISSELECTEDMEASURE and ISFILTERED that might help. But, I can't picture what you are trying to do. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

@Greg_Deckler 

 

sorry if the post was confusing

i have a table" Pipeline Extract" in which some of the "Coloumns" i am using as slicer

when i select any value of the slicer ( i have used a card for Title) it should dynamically change based on my slicer selection

 

so it was working well with "selectedValue function", but i can only use this function for 1 slicer(coming as coloumn from my table)

Do you have a solution now?

hope it clears

 

Anonymous
Not applicable

I think you have not closed parenthesis of selectedvalue correctly.
Your screenshot is not clearly visible in my phone.

One more thing use selectedvalue function with column only not with measures.
For measures directly add them in formula without selectvalue.

Make sure all columns have datatype. If not then use format function to make them in one format.

Thanks
Pravin

If it resolves your problem mark it as a solution and give Kudos.

Anonymous
Not applicable

I am assuming you have multiple slicers on diff columns and you want to show selected value in each slicer.

You have to concatenate all selected values like this.

Header= selectedvalue(table,[col1]) & selectedvalue(table,[col2])

Thanks,
Pravin

If it resolves your problem Mark it as a solution and give Kudos.
vjnvinod
Impactful Individual
Impactful Individual

Capture.PNG

@Anonymous 

 

not working actually, see the error

Helpful resources

Announcements
New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

March Power BI Update Carousel

Power BI Community Update - March 2026

Check out the March 2026 Power BI update to learn about new features.