Waterfall - different breackdowns by category

Question

Hello,I have created a waterfall to visualize my production times.I would like to know if it is possible to display different breckdowns by category.for examplefor opening time I want to display only AA_Closing timefor the required time I want to display only C_planned timefor the useful time I want to display the rest&nbsp;this means that I don't want to display the values at zeroi can't make this visual do you think it's possible&nbsp;&nbsp;

danextian · Answer

Hi Elglouton2 
&nbsp;
You will need to write a measure that conditional filters which breakdown to show based on the current category. Example:
SWITCH (
    SELECTEDVALUE ( Data[Category] ),
    "AA_Closing time", CALCULATE ( [My Measure], KEEPFILTERS ( Data[Breakdown] = "aa closing time" ) ),
    "Required time", CALCULATE ( [My Measure], KEEPFILTERS ( Data[Breakdown] = "c planned time" ) ),
    "Useful time",
        CALCULATE (
            [My Measure],
            KEEPFILTERS ( NOT Data[Breakdown] IN { "aa closing time", "c planned time" } ) --exclude these two breakdowns
        )
)

elglouton2 · Answer

Hello,I've tried to adapt the measurement to what I use, but without success.I'm getting confused about the order in which to make the switches ... I'm going about it all wrong and don't understand everythingsorry but do you think your solution can be adapted to this measure?&nbsp;Tps Water Spe_L1 =var selectedCategory = SELECTEDVALUE(Category[Category])var selectedBreakdown = SELECTEDVALUE(Breakdown[Breakdown])return&nbsp; &nbsp; SWITCH(selectedCategory,&nbsp; &nbsp; &nbsp; &nbsp; "Temps Total",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SWITCH(selectedBreakdown, &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;"AA_Tps Fermeture", 0,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;"C_Tps Planifié", 0,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;"E_Cgt Lot", 0,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;"F_Cgt Conso", 0,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;"G_Tps Pannes", 0,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;"H_Tps Orga", 0,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;"I_Tps Injustifié", 0,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SUM(T_BDD_Saisie_Ligne1[Temps total (Jour)])&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ),"Tps Ouverture",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SWITCH(selectedBreakdown,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "AA_Tps Fermeture", -1*SUM(T_BDD_Saisie_Ligne1[Temps fermeture (Jour)_F]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "C_Tps Planifié", 0,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "E_Cgt Lot", 0,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "F_Cgt Conso", 0,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "G_Tps Pannes", 0,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "H_Tps Orga", 0,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "I_Tps Injustifié", 0,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SUM(T_BDD_Saisie_Ligne1[Temps Ouverture])&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ),"Tps Requis",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SWITCH(selectedBreakdown,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "AA_Tps Fermeture", -1*SUM(T_BDD_Saisie_Ligne1[Temps fermeture (Jour)_F]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "C_Tps Planifié", -1*SUM(T_BDD_Saisie_Ligne1[Somme_C]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "E_Cgt Lot", 0,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "F_Cgt Conso", 0,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "G_Tps Pannes", 0,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "H_Tps Orga", 0,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "I_Tps Injustifié", 0,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SUM(T_BDD_Saisie_Ligne1[Temps requis])&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp; &nbsp; &nbsp; &nbsp; "Tps Utile",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SWITCH(selectedBreakdown,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "A_Tps Total", SUM(T_BDD_Saisie_Ligne1[Temps total (Jour)]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "AA_Tps Fermeture", -1*SUM(T_BDD_Saisie_Ligne1[Temps fermeture (Jour)_F]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "B_Tps Ouverture", SUM(T_BDD_Saisie_Ligne1[Temps Ouverture]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "C_Tps Planifié", -1*SUM(T_BDD_Saisie_Ligne1[Somme_C]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "D_Tps Requis", SUM(T_BDD_Saisie_Ligne1[Temps requis]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "E_Cgt Lot", -1*SUM(T_BDD_Saisie_Ligne1[CG_I]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "F_Cgt Conso", -1*SUM(T_BDD_Saisie_Ligne1[Somme_A]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "G_Tps Pannes", -1*SUM(T_BDD_Saisie_Ligne1[Somme_P]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "H_Tps Orga", -1*SUM(T_BDD_Saisie_Ligne1[Somme_O]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "I_Tps Injustifié", -1*SUM(T_BDD_Saisie_Ligne1[Temps injustifié]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "J_Tps Utile", SUM(T_BDD_Saisie_Ligne1[Temps Utile (TRP)]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SUM(T_BDD_Saisie_Ligne1[Temps utile])&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; )&nbsp;&nbsp;

danextian · Answer

You already are using a measure in your waterfall breakdown, aren't you? Why not use that within calculate?
CALCULATE ( [My Measure], KEEPFILTERS ( Data[Breakdown] = "aa closing time" ) 
&nbsp;
or this
My Measure with OR Conditions =
CALCULATE (
    [My Measure],
    KEEPFILTERS ( ( Data[Category] = "AA_Closing time"
        &amp;&amp; Data[Breakdown] = "aa closing time" )
        || ( Data[Category] = "Required time"
        &amp;&amp; Data[Breakdown] = "c planned time" )
        || ( Data[Category] = "Useful time"
        &amp;&amp; NOT ( Data[Breakdown]
        IN {
            "aa closing time",
            "c planned time"
        } ) ) )
)

elglouton2 · Answer

I use this measurement for my y axisI can't put a measurement in the breakdown zone&nbsp;&nbsp; I've tried to modify the code but my 6 breakdowns are still present.&nbsp;&nbsp;Tps Water Spe_L1_ =var selectedCategory = SELECTEDVALUE(Category[Category])var selectedBreakdown = SELECTEDVALUE(Breakdown[Breakdown])return&nbsp; &nbsp; SWITCH(selectedCategory,&nbsp; &nbsp; &nbsp; &nbsp; "Temps Total",&nbsp; &nbsp; &nbsp; &nbsp; CALCULATE (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SWITCH(selectedBreakdown,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "AA_Tps Fermeture", 0,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "C_Tps Planifié", 0,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "E_Cgt Lot", 0,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "F_Cgt Conso", 0,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "G_Tps Pannes", 0,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "H_Tps Orga", 0,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "I_Tps Injustifié", 0,&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;SUM(T_BDD_Saisie_Ligne1[Temps total (Jour)])&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp; &nbsp; KEEPFILTERS ( ( Category[Category] = "Temps Total"&nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp; selectedBreakdown = "AA_Tps Fermeture" )&nbsp; &nbsp; &nbsp; &nbsp; || ( Category[Category] = "Temps Total"&nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp; selectedBreakdown = "C_Tps Planifié" ) &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; || ( Category[Category] = "Temps Total"&nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp; selectedBreakdown = "E_Cgt Lot" )&nbsp; &nbsp; &nbsp; &nbsp; || ( Category[Category] = "Temps Total"&nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp; NOT ( selectedBreakdown&nbsp; &nbsp; &nbsp; &nbsp; IN {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "AA_Tps Fermeture",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "E_Cgt Lot"&nbsp; &nbsp; &nbsp; &nbsp; } ) ) )),"Tps Ouverture",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SWITCH(selectedBreakdown,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;"AA_Tps Fermeture", -1*SUM(T_BDD_Saisie_Ligne1[Temps fermeture (Jour)_F]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;"C_Tps Planifié", 0,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;"E_Cgt Lot", 0,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "F_Cgt Conso", 0,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "G_Tps Pannes", 0,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "H_Tps Orga", 0,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "I_Tps Injustifié", 0,&nbsp;&nbsp;SUM(T_BDD_Saisie_Ligne1[Temps Ouverture])&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ),"Tps Requis",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SWITCH(selectedBreakdown,"AA_Tps Fermeture", -1*SUM(T_BDD_Saisie_Ligne1[Temps fermeture (Jour)_F]),"C_Tps Planifié", -1*SUM(T_BDD_Saisie_Ligne1[Somme_C]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;"E_Cgt Lot", 0,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "F_Cgt Conso", 0,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "G_Tps Pannes", 0,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "H_Tps Orga", 0,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "I_Tps Injustifié", 0,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;SUM(T_BDD_Saisie_Ligne1[Temps requis])&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp; &nbsp; &nbsp; &nbsp; "Tps Utile",&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;CALCULATE (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SWITCH(selectedBreakdown,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "A_Tps Total", SUM(T_BDD_Saisie_Ligne1[Temps total (Jour)]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "AA_Tps Fermeture", -1*SUM(T_BDD_Saisie_Ligne1[Temps fermeture (Jour)_F]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "B_Tps Ouverture", SUM(T_BDD_Saisie_Ligne1[Temps Ouverture]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "C_Tps Planifié", -1*SUM(T_BDD_Saisie_Ligne1[Somme_C]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "D_Tps Requis", SUM(T_BDD_Saisie_Ligne1[Temps requis]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "E_Cgt Lot", -1*SUM(T_BDD_Saisie_Ligne1[CG_I]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "F_Cgt Conso", -1*SUM(T_BDD_Saisie_Ligne1[Somme_A]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "G_Tps Pannes", -1*SUM(T_BDD_Saisie_Ligne1[Somme_P]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "H_Tps Orga", -1*SUM(T_BDD_Saisie_Ligne1[Somme_O]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "I_Tps Injustifié", -1*SUM(T_BDD_Saisie_Ligne1[Temps injustifié]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "J_Tps Utile", SUM(T_BDD_Saisie_Ligne1[Temps Utile (TRP)]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;SUM(T_BDD_Saisie_Ligne1[Temps utile])&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp; &nbsp; KEEPFILTERS ( &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;( Category[Category] = "Tps Utile"&nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp; selectedBreakdown = "C_Tps Planifié" ) &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; || ( Category[Category] = "Tps Utile"&nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp; NOT ( selectedBreakdown&nbsp; &nbsp; &nbsp; &nbsp; IN {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "AA_Tps Fermeture",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "E_Cgt Lot"&nbsp; &nbsp; &nbsp; &nbsp; } ) ) ))&nbsp; &nbsp; )&nbsp;

Forum Discussion

Waterfall - different breackdowns by category

4 Replies

Related content

Waterfall with different measures and different colours

Waterfall Chart

Waterfall Chart Help

Waterfall with multiple values

Waterfall Charts with running totals