Dynamic title: my title should show the selected planning category in slicer

[theunissenp]

Hello Guys,

I created a report using a slicer where the user can select the desired planning category. My visual title or report title (or both) should show the selected value in the slicer?

Is this possible in Power BI an dif so how?

May thanks!

Paul

[CheenuSing · Accepted solution]

Hi @theunissenp 

Please refer the link

https://blog.crossjoin.co.uk/2016/04/25/dynamic-chart-titles-in-power-bi/

Cheers

CheenuSing

[theunissenp]

Hello @CheenuSing 

My result should be as follows. If one category is selected then it should show in the title. If more selected it should give the result 'costs per region multiple catgories'

I used the following coding and i'm getting the following error: 'invalid token line 16 offset 31'

Have you got any idea what went wrong?

Title2 =
VAR SelectedCategories =
VALUES ( 'Ocin_Logistic'[Category.Category level 01] )
VAR NumberOfSelectedCategories =
COUNTROWS ( SelectedCategories )
RETURN
"Cost per Region "
& IF (
NumberOfSelectedCategories > 1,
"Multiple Categories",
"For "
& IF (
NumberOfSelectedDays = 1,
"",
CONCATENATEX (
VALUES(‘OCIN_LOGISTIC'[CATEGORY.CATEGORY Level 01]), ’OCIN_LOGISTIC'[CATEGORY.CATEGORY Level 01],
“, “)
)

regards

Paul

[CheenuSing]

Hi @theunissenp 

Just corrected the syntax , try this out

Title2 =
VAR SelectedCategories =
    VALUES ( 'Ocin_Logistic'[Category.Category level 01] )
VAR NumberOfSelectedCategories =
    COUNTROWS ( SelectedCategories )
RETURN
    "Cost per Region "
        & IF (
            NumberOfSelectedCategories > 1,
            "Multiple Categories For "
            
                & IF (
                    NumberOfSelectedDays = 1,
                    "",
                    CONCATENATEX (
                        VALUES ( 'OCIN_LOGISTIC'[CATEGORY.CATEGORY Level 01] ),
                        'OCIN_LOGISTIC'[CATEGORY.CATEGORY Level 01],
                        ", "
                    )
                )
        )

Cheers

CheenuSing

[theunissenp]

@CheenuSing Thanks! Now it's working fine!