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.

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! 🏅

Irwan's avatar
Irwan
Super User
2 years ago

hello Anonymous 

 

glad to be a help.

 

Thank you.