Forum Discussion
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...
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")ReturnIF(_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, 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
Super User
Super Userhello 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.