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

Get inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Kudoed Authors