Dynamic Report title based on multiple slicer selection from different table

[P_P2595]

Hi All,

Is it possible to create a dynamic title for the report by selecting multiple slicers from different tables?

Ex. I have two different tables:

Table 1 :

Slicer : (ATYPE)

Value: zxcv, qsc, efv, tgb, yuj,ikm,opl

Table 2 :

Slicer : (CTYPE)

Value: mnb,ghj,der,tyg,tuj,ijk,lnm

Based on the slicer selection from two different tables want to change the title.

If I select the zxcv, qsc and mnb hen title should be supported

If I select the qsc, ghj and der then title should be program supported

Is it possible in power bi?

Thank you in advance.

[amitchandak]

@P_P2595 ,

a new measure

Switch(true() ,

countrows(filter(Table1[ATYPE] in {"zxcv", "qsc" ,"mnb"})) >0 , "Supported",

countrows(filter(Table1[CTYPE] in {" qsc", "ghj","der"})) >0 , "program  Supported",

"Others"

)

change order, to change preferenece

or

Create another measure to determine the dynamic title based on the selected values:
Report_Title =
VAR Selected_ATYPE = CONCATENATEX(ALLSELECTED('Table 1'[ATYPE]), 'Table 1'[ATYPE], ", ")
VAR Selected_CTYPE = CONCATENATEX(ALLSELECTED('Table 2'[CTYPE]), 'Table 2'[CTYPE], ", ")
RETURN
SWITCH(TRUE(),
Selected_ATYPE = "zxcv, qsc" && Selected_CTYPE = "mnb", "Supported",
Selected_ATYPE = "qsc" && Selected_CTYPE = "ghj, der", "Program Supported",
BLANK()
)

[P_P2595]

Hi Amitchandak,

2nd measure is perfectly working with a single selected value, but not working with multiple selections.

If I Select two values (zxcv, qsc), (ghj, der) it's not working

Selected_ATYPE = "zxcv, qsc" && Selected_CTYPE = "mnb", "Supported",
Selected_ATYPE = "qsc" && Selected_CTYPE = "ghj, der", "Program Supported",

[P_P2595]

Hi Amitchandak,

Thanks for your prompt response,

Here I am using two different tables to filter the data.

So these two values zxcv, qsc coming from the 1st table and mnb is coming from the 2nd table.

Sameway qsc coming from the 1st table and ghj and der coming from the 2nd table

Thanks