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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Fx for titles not working for me or my team

I am attempting to use the Fx on visual titles.  When I attemt to use it, all values are grayed out.  My team members have the same issue.  I am on the lastest version of PBI.

I have attempted to use the visual Title Fx.  When I open the window, I get Field value, with not values in drop down.  the "What field should we base this on?  All values in my model are grayed out.

I have tried the new and old version of formatting pane.

suzanneshuford_0-1646857093418.png

I would appreciate any help or guidance anyone can give me.

Suzanne

1 ACCEPTED SOLUTION
calerof
Impactful Individual
Impactful Individual

Hi @Anonymous ,

You can create a measure for the title like this one:

Title Sales = 
VAR ProductSelected = SELECTEDVALUE('Product'[ProductName], "All Products")
RETURN
COMBINEVALUES(" ", "Sales of ", ProductSelected)

Then in the visual you want the title, go to Format, General, Title, then fx, Field value and then you choose your Title measure.

It looks like this:

image1.png

 

Hope it helps.

Fernando

View solution in original post

4 REPLIES 4
tunikipati
New Member

I'ts not working for me .I'm unable to select the option 

calerof
Impactful Individual
Impactful Individual

What are you trying to accomplish?

Anonymous
Not applicable

I am trying to use dynamic titles.  I have used them before.  As Simple as title = "this is my title" && Max(date dim[date])

 

calerof
Impactful Individual
Impactful Individual

Hi @Anonymous ,

You can create a measure for the title like this one:

Title Sales = 
VAR ProductSelected = SELECTEDVALUE('Product'[ProductName], "All Products")
RETURN
COMBINEVALUES(" ", "Sales of ", ProductSelected)

Then in the visual you want the title, go to Format, General, Title, then fx, Field value and then you choose your Title measure.

It looks like this:

image1.png

 

Hope it helps.

Fernando

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.