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.
Hi Anonymous ,
You can just simple add visual level filter on Bar graph ,
where ,
delivery time= late
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!
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.