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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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