Forum Discussion
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])Returnif (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")))))If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
3 Replies
- Ritaf1983Super User
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])Returnif (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")))))If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
- AnonymousNot applicable
This makes sense, and it works, thanks!
- Ritaf1983Super User
Glad to help , sorry that there is no quick and easy solution☺️