Forum Discussion

P_P2595's avatar
P_P2595
Icon for Helper I rankHelper I
3 years ago

Dynamic Report title based on multiple slicer selection from different table

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,...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

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()
)