How to add Stage as filter ?

[Paulyeo11]

Hi All

I have a field name = Stage , i need user able to select the Stage like 1 and 2 only . 

My PBI file :-

https://www.dropbox.com/s/lcxrk7msvq64lf1/NEXT3MTH%20V001%20ASH%20SOLUTION_3.pbix?dl=0

[Anonymous]

A pattern cannot be specified when creating a stage, but operations performed over the stage can apply a pattern, which can help ignore your known bad files.

Patterns on stage files can be applied when listing a stage, quirying a stage directly, and when performing COPY INTO <TABLE> FROM <STAGE> commands .

The COPY INTO <TABLE> options also permit passing an ON_ERROR='CONTINUE' option  to automatically ignore unreadable rows in any file being loaded.

[Anonymous · Accepted solution]

@Paulyeo11 ,

I would suggest you to use a slicer instead of the table.

Click on your table and then from visualization pane, select slicer icon.

Now when the table is converted into slicer, open the filter pane and then you can choose what you want to remove.

Appreciate your kudos !! Mark this post as solution if this helps.

[MFelix]

Transform the table into a slicer, and apply a filter on the report so we can only see stage 1 and 2.