Dynamic Title

[RanjanThammaiah]

Hi Team,

Can some one help me to correct the below formula.

I have attched a image for the better understanding.. Title working perfectly wjen i select any value in the filter. If i select all the titel is appearing as Blank.

i just want to appear as'Oceania Campaign Solution" when i select all the values in the filter.

Solution header =

SELECTEDVALUE (Solution[Identification])

& IF(HASONEVALUE(Solution[Identification]), " ", "")

[v-piga-msft · Accepted solution]

Hi @RanjanThammaiah ,

Please try the measure below.

Measure =
IF (
    ISFILTERED ( 'Table (2)'[Title] ),
    SELECTEDVALUE ( 'Table (2)'[Title], "All" ),
    "Oceania Campaign Solution"
)

Here is the output.

Best Regards,

Cherry

[Anonymous]

Hi @RanjanThammaiah ,

Go through the below URL, Hope this helps a lot,

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-april-2019-feature-summary/#dynamicTitles

Regards,

Pradeep