Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Dynamic Title with Values from Multiple Slicers

Hi all,

 

I have a table with categories scattered across four columns (branch, digital, email, cbcc) and they all have the same yes/no values e.g., "Branch" or "Not Branch". I'm allowing users to select only the "yes" values as I'm filtering out the "no" values for all columns in each of the four slicers below:

 

 

I want to have a dynamic title that can only show selected values, for instance, looking at the above image: "12 Months Rolling Forecast - Digital, CBCC Outbound",  and this title should change when 1, 2, 3, or all 4 values are selected. If no values values are selected I want to show "12 Months Rolling Forecast - Overall". 

 

This is what I have so far but I'm getting nowhere:

 

 

 

Forecast Title = 

var _branch = ISFILTERED ( Leads_summary_db2[Centrel_opp_fc] )
var _digital = ISFILTERED ( Leads_summary_db2[Digital_fc] )
var _email = ISFILTERED( Leads_summary_db2[Email_fc] )
var _cbcc = ISFILTERED( Leads_summary_db2[CCC_outbound_fc] )

return

  "12 Months Rolling Forecast - " &
   SWITCH( TRUE() , 
      AND ( _branch , NOT ( _digital ) ) , "Branch",
      AND ( _digital , NOT ( _branch ) ) , "Digital",
      AND ( _email , NOT ( _branch ) ) , "Email",
      AND ( _cbcc , NOT ( _branch ) ) , "CBCC Outbound",
      AND ( _digital = TRUE , _branch = TRUE ) , "Branch, Digital" ,
      AND ( _email = TRUE , _branch = TRUE ) , "Branch, Email" ,
      AND ( _cbcc = TRUE , _branch = TRUE ) , "Branch, CBCC Outbound" ,
      "Overall"
   )

 

 

 

Thanks so much in advance.

  • Hi Anonymous 
    To make it work you need your Dax to have all possible scenarios of selections .
    I created a measure of 4 of them just to show you how it works, you need to continue from here :

    test =
     var branch = ISFILTERED('Table'[Branch])
     var digital = ISFILTERED('Table'[Digital])
     var email = ISFILTERED('Table'[email])
     var cbcc = ISFILTERED('Table'[cbcc])
    Return
    if (branch=false && digital=true && email= true && cbcc = true, "12 Months Rolling Forecast - digital,email,cbcc",
    if (branch=false && digital=false && email= true && cbcc = true, "12 Months Rolling Forecast - email,cbcc",
    if (branch=false && digital=false && email= true && cbcc = true, "12 Months Rolling Forecast - email,cbcc",
    if(branch=false && digital=false && email= false && cbcc = true, "12 Months Rolling Forecast -cbcc",
    if(branch=true && digital=true && email= true && cbcc = true, "12 Months Rolling Forecast - digital,email,cbcc","you need to continue with  your conditions"

    )))))

    Link to a sample file 

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

3 Replies

  • Hi Anonymous 
    To make it work you need your Dax to have all possible scenarios of selections .
    I created a measure of 4 of them just to show you how it works, you need to continue from here :

    test =
     var branch = ISFILTERED('Table'[Branch])
     var digital = ISFILTERED('Table'[Digital])
     var email = ISFILTERED('Table'[email])
     var cbcc = ISFILTERED('Table'[cbcc])
    Return
    if (branch=false && digital=true && email= true && cbcc = true, "12 Months Rolling Forecast - digital,email,cbcc",
    if (branch=false && digital=false && email= true && cbcc = true, "12 Months Rolling Forecast - email,cbcc",
    if (branch=false && digital=false && email= true && cbcc = true, "12 Months Rolling Forecast - email,cbcc",
    if(branch=false && digital=false && email= false && cbcc = true, "12 Months Rolling Forecast -cbcc",
    if(branch=true && digital=true && email= true && cbcc = true, "12 Months Rolling Forecast - digital,email,cbcc","you need to continue with  your conditions"

    )))))

    Link to a sample file 

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

    • Anonymous's avatar
      Anonymous
      Not applicable

      This makes sense, and it works, thanks!

      • Ritaf1983's avatar
        Ritaf1983
        Super User

        Glad to help , sorry that there is no quick and easy solution☺️