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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
rpinxt
Impactful Individual
Impactful Individual

Can I make part of my title in red?

I have this DAX code to make a dynamic title:

LBE Comp. =
VAR MinLBE = LOOKUPVALUE('AVN MD Type'[Type],'AVN MD Type'[ID],MIN('AVN MD Type'[ID]))
VAR MaxLBE = LOOKUPVALUE('AVN MD Type'[Type],'AVN MD Type'[ID],MAX('AVN MD Type'[ID]))
VAR Warning = IF([TypeCount] > 2, "     *(More than 2 selected)"  )
RETURN
"LBE Comparison between " & MinLBE & " and " & MaxLBE & Warning
 
Now as I already showed here I would like to, whenever more than 2 of the slicer are selected, to add this warning to the title in red.
2 ACCEPTED SOLUTIONS
miTutorials
Super User
Super User

If the title contains certain text, say for example "More than 2 selected" - The entire title can be changed to Red.

 

Partial text is not possible.

View solution in original post

rpinxt
Impactful Individual
Impactful Individual

Ok thanks @miTutorials .

Then it is not possible and dax cannot do it.

 

It is a combined title:

rpinxt_0-1715771196242.png

 

Already had a subtitle. But will put that part in the main title and then the warning in the subtitle.

 

Answer is that it cannot be done, solution is to use the subtitle.

 

View solution in original post

2 REPLIES 2
rpinxt
Impactful Individual
Impactful Individual

Ok thanks @miTutorials .

Then it is not possible and dax cannot do it.

 

It is a combined title:

rpinxt_0-1715771196242.png

 

Already had a subtitle. But will put that part in the main title and then the warning in the subtitle.

 

Answer is that it cannot be done, solution is to use the subtitle.

 

miTutorials
Super User
Super User

If the title contains certain text, say for example "More than 2 selected" - The entire title can be changed to Red.

 

Partial text is not possible.

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.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel1

Power BI Monthly Update - May 2024

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