combined values title

[djemy1975]

Dear colleagues ,

I am going to create a dynamic title for my chart in power BI ,and I want to concatenate two slicers in this title
1- department slicer
2- month slicer

I want to display title as "Expenses by "Month" & "Department, when slicers are selected

I have the following measures:

Selected Month = VAR GetValues=CONCATENATEX(
VALUES('Date'[Month]); 'Date'[Month]; " & ")
RETURN
"Expenses by " & GetValues & " "

and

Selected Dept. = VAR GetValues=CONCATENATEX(
VALUES('mapping'[Département]); 'mapping'[Département]; " & ")
RETURN
" " & GetValues & " "

and title measure which combines both:

Title = COMBINEVALUES(" " ; [Selected Month] ;"for"; [Selected Dept.])

I have a small problem that when nothing is selected the title becomes so long ,whereas I want to display "no selection is made" or "all months for all departments" instead.


I think it has to do with "if isfiltered" function.

Best regards,

 

[Bo_Ry]

Yes, please try

Selected Month
=VAR GetValues
    =if(ISFILTERED( 'date'[Month])
        ,CONCATENATEX(VALUES('Date'[Month]), 'Date'[Month], " & ")
        ,"no selection is made"
    )
RETURN "Expenses by " & GetValues & " "

 

[djemy1975]

Yes, please try

Selected Month
=VAR GetValues
    =if(ISFILTERED( 'date'[Month])
        ,CONCATENATEX(VALUES('Date'[Month]), 'Date'[Month], " & ")
        ,"no selection is made"
    )
RETURN "Expenses by " & GetValues & " "

Thank you for your reply .I have used this function with slight modification replacing "no selection is made" with "All months".It works for months but still the problem with departments though I have made
the same as selected month function
.

Is there any workaround to solve this issue?
Regards,

 

[Bo_Ry]

The logic is the same

Selected Dept.
=VAR GetValues
    =if(ISFILTERED( 'mapping'[Département])
        ,CONCATENATEX(VALUES('mapping'[Département]), 'mapping'[Département], " & ")
        ,"All Departement"
    )
RETURN " " & GetValues & " "

 

[djemy1975]

The logic is the same

Selected Dept.
=VAR GetValues
    =if(ISFILTERED( 'mapping'[Département])
        ,CONCATENATEX(VALUES('mapping'[Département]), 'mapping'[Département], " & ")
        ,"All Departement"
    )
RETURN " " & GetValues & " "

 

[djemy1975]

It is working when using it in a visual card but not when used it as a title inside chart .Any ideas?