Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Xboraxe
Frequent Visitor

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:

 

Screenshot 2023-08-09 102045.png

 

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.

1 ACCEPTED SOLUTION
Ritaf1983
Super User
Super User

Hi @Xboraxe 
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"

)))))
Ritaf1983_0-1691645276860.pngRitaf1983_1-1691645317569.pngRitaf1983_2-1691645347849.pngRitaf1983_3-1691645378883.png

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

View solution in original post

3 REPLIES 3
Ritaf1983
Super User
Super User

Hi @Xboraxe 
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"

)))))
Ritaf1983_0-1691645276860.pngRitaf1983_1-1691645317569.pngRitaf1983_2-1691645347849.pngRitaf1983_3-1691645378883.png

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

This makes sense, and it works, thanks!

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

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors