Help with how to return the original dataset after applyng a filter

[Anonymous]

Hi,

I have applied a filter on a column called "Suburb" and I want to find errors on another column. After I replaced errors with certain values, I applied changes. Now I want to see the origincal dataset with changes made. However, I cannot get back to the original data with changes. It only shows the dataset with filters. Please assist.

Many thanks.

[v-danhe-msft]

Hi @Anonymous ,

Could you have tried to click the "Click filter" to remove the filters:

Regards,

Daniel He

[Anonymous]

Thanks for the help. I will try this and let you know.

[v-danhe-msft]

Hi @Anonymous ,

OK, if your problem could be solved, could you please mark the helpful replies as Answered to close this topic? 

Regards,

Daniel He

[Anonymous]

Hi,

I have checked the solution you provided but I cannot see that filter option to get back the dataset after making changes. If I give you more context, in power query editor I used filtering to remove some values from a column. After making changes I want to see the full dataset with the changes I made. Is this possible? because at the moment I only get the table with the filters.

Many thanks in advance.

[Ashish_Mathur]

Hi,

In the Query Editor, click on the step (just before the Filter step) in the Applied steps pane.

[Anonymous]

Hi Ashish_Mathur, thank you for the response. However, it won't show the dataset with the changes applied in filtering.

[Ashish_Mathur]

Hi,

Perhaps i do not understand your question.  May be someone else can help.

[amii628]

Hi @Ashish_Mathur 

I have a similar sort of problem, if i can explain it as below. I have a dataset  as below:

Units Sold	date	No sale	Less then 5	Acieved Target
0	Monday	TRUE	TRUE	FALSE
5	Tuesday	FALSE	FALSE	TRUE
0	wednesday	TRUE	TRUE	FALSE
6	Thursday	FALSE	FALSE	TRUE
4	Friday	FALSE	TRUE	FALSE
2	Saturday	FALSE	TRUE	FALSE
0	Sunday	TRUE	TRUE	FALSE

The basic data set is just Number of units sold and day of the week and is being repeated again and again for previous weeks (I have excluded the date thing to make it simple). Then i created these three calculated columns to find simple true and false if there is no sale/less sale/target acheived. 

Then with a simple measure i counted the number of trues in each calculated columns to see how many days there is no sale, how many days its less and for how many days we achieved the target. I am using a chart and a visual where visual only show the number of days(Measure) for all three. 

Now by applying the filter to any of the column it filters the tables, however when i click on number of days in the visual, it doesnt filter the table for days. 

Hope i made my point. 

Any Suggestions. 

[Ashish_Mathur]

Hi,

You need not create 3 calculated columns.  These measures should work

Days of No sale = CALCULATE(COUNTROWS(Data),Data[Units sold]=0)

Days on which < 5 units were sold = CALCULATE(COUNTROWS(Data),Data[Units sold]>0,Data[Units sold]<5)

Days on which target was achieved = CALCULATE(COUNTROWS(Data),Data[Units sold]>=5)

Hope this helps.