Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Filter bar chart

How I can filter this bar chart to only keep projects (bars) that have late deliveries, i.e. only show projects A and B in this example? Sample data table is below Sample data table: del...
Need Help
  • Irwan's avatar
    Irwan
    2 years ago

    hello Anonymous 

     

    please check if this what you need.

     

    If this what you need, then you can create new measure with conditional if or switch.

    Measure =
    var _Late = CALCULATE(COUNT('Table'[Delivery time]),'Table'[Delivery time]="Late")
    Return
    IF(
        _Late>0,
        COUNT('Table'[Delivery time])
    )
     
    then change the x-axis value into the measure that has been made above.

     

    Hope this will help you.

    Thank you.

manvishah17's avatar
manvishah17
Icon for Solution Supplier rankSolution Supplier
2 years ago

Hi Anonymous ,
You can just simple add visual level filter on Bar graph ,
where ,
delivery time= late 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    manvishah17, thank you for your suggestion, but I do want to show the On time deliveries for these projects. So, your solution is not what I am looking for. I am looking to only display Projects that have late deliveries but I want to display ALL of their deliveries, not only late. Thanks!

    • Irwan's avatar
      Irwan
      Icon for Super User rankSuper User
      2 years ago

      hello Anonymous 

       

      please check if this what you need.

       

      If this what you need, then you can create new measure with conditional if or switch.

      Measure =
      var _Late = CALCULATE(COUNT('Table'[Delivery time]),'Table'[Delivery time]="Late")
      Return
      IF(
          _Late>0,
          COUNT('Table'[Delivery time])
      )
       
      then change the x-axis value into the measure that has been made above.

       

      Hope this will help you.

      Thank you.

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Irwan, thank you so much! It worked perfectly! I really appreciate your help. Thank you for taking the time to help me! 🏅