Forum Discussion

P_P2595's avatar
P_P2595
Helper 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
Super 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()
)

  • P_P2595's avatar
    P_P2595
    Helper I
    3 years ago

    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

  • P_P2595's avatar
    P_P2595
    Helper I
    3 years ago

    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",