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.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
2 years ago

Hi,

Share the dowload link of the PBI file.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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