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

    Hi v-diye-msft 

    Excellent, thank you - the slicer your created is exactly what I need.

     

    I'm missing something though.

    The new table, with the desired filter selections - is there something special about creating/configuring that?
    Theres no relationships and its just text?
    When I add additional options or change the numbers in edit source it doesnt filter anything and breaks what you've setup, even if i just flip an operator, "<" to ">".  Or even if I change 100 to 99.

     

     

    Trying to reverse engineer it, can you see what I'm missing?

    - Enter Data

    - Type out the desired filter options you want in a single column: "Measure < 100" "Measure >= 100"

    - New Slicer visual with the filter column

    - Visual filter on bar chart - Measure not blank

    • 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