show values for items not in selected month

[mudegowdrp]

I have folder and I'll be exporting data monthly to that folder.

Example: I have 3 files as of now 1-jan-2018, 1-feb-2018, 3-feb-2018

1-Jan-2018 has following data.

ID                                             Status

xyz_001                                    New

xyz_002                                    New

xyz_003                                    In Progress

xyz_004                                    In Progress

1-Feb-2018 has following data.

xyz_001                           In Progress

xyz_002                           In Progress

xyz_003                           In Progress

xyz_005                           New

1-Mar-2018 has following data

xyz_003                          In Progress

xyz_007                          New

xyz_008                           In Progress

So in the February file I dont have resolved items i.e xyz_004   and in march xyz_001 and xyz_002 are resolved

How can I see in bar graph when I click on Feb Resolved Items?

Please help

Thanks

[Greg_Deckler]

Well, you can use ALL or ALLEXCEPT to change the context of the filters on your measure. I'm not exactly sure of what you are trying to accomplish here in terms of what should the output be?

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[mudegowdrp]

@Greg_DecklerI know I didnot put that in a good format. I have csv files coming in every month which shows InProgress and OPen tickets. But when the tickets are resolved they dissappear from next month. How do I show in the visualiation "How many tickets are resolved in specific month" compared to previous months.

Thanks