Filter bar chart

[fluffysnow]

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:

delivery id	Project name	Delivery time
1	Project A	On time
2	Project B	On time
3	Project A	On time
4	Project C	On time
5	Project C	On time
6	Project A	On time
7	Project B	On time
8	Project C	On time
9	Project D	On time
10	Project D	On time
11	Project A	On time
12	Project B	On time
13	Project D	On time
14	Project E	On time
15	Project A	Late
16	Project B	Late
17	Project A	Late

[manvishah17]

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

[fluffysnow]

@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 · Accepted solution]

hello @fluffysnow 

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.

[fluffysnow]

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

[Irwan]

hello @fluffysnow 

glad to be a help.

Thank you.

[Ashish_Mathur]

Hi,

Share the dowload link of the PBI file.

[fluffysnow]

I cant share the file. It's proprietory data. See sample data file above. Thanks!