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

Need Help

3 Replies

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