Forum Discussion

jcolby's avatar
jcolby
Icon for Helper I rankHelper I
7 years ago
Solved

Button/Slicer for using different filter on a stacked bar chart

Greetings,   Been stuck for a while on this, poured over the forum/google and still unsure.   I have a stacked barchart consisting of a measure(effective rate) and a column(hours) with a Company ...
Need Help
jcolby's avatar
jcolby
Icon for Helper I rankHelper I
7 years ago

v-diye-msft 

 

ahhhhh, wasnt paying attention - didnt see the measure (i thought it was my measure lol)

 

Thank you!

 

 

jcolby's avatar
jcolby
Icon for Helper I rankHelper I
7 years ago

v-diye-msft 

Tweaked your solution a bit and used a SWITCH statement

Effective Rate (Filtered) = 
SWITCH(
    SELECTEDVALUE('Filters'[ Effective Rate]),
    "< 100", CALCULATE(
        [Effective Rate #],
        FILTER(Companies,[Effective Rate #] < 100)
    ),
    ">= 100", CALCULATE(
        [Effective Rate #],
        FILTER(Companies,[Effective Rate #] >= 100)
    ),
    [Effective Rate #]
)

 

Thanks again, pushed my understanding wrestling with this problem