Filter tables in report builder

[dogburalHK82]

Hi, 

I have a table listing a few columns. 

If I want to list only PO numbers with condition of "Late" and "Early", what express I need to use?

PO Number	Delivery date	Condition
PO111	12/01/2024	Late
PO222	12/01/2024	Early
PO333	12/01/2024	On Time
PO444	12/01/2024	Late

Each column expression as below

PO Number : =Fields!Purchase_Order.Value

Delivery Date : =Fields!Delivery_Date.Value

Condition : = =Fields!Condition_switch.Value

[v-xiandat-msft]

Hi @dogburalHK82 ,

First, you can right-click on the dataset to open it and find filter and enter the form in the following image

The final output is shown in the following figure:

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[dogburalHK82]

@v-xiandat-msft thank you for the help. 

However, for some reason my data is recognized as Integer, not String. 

Below is the real data. 

In Power BI, the data is derived from below 

How can i convert it?

[v-xiandat-msft · Accepted solution]

Hi @dogburalHK82 ,

You can convert it in expression:

expression = format(Fields!Condition_switch.Value , "string")

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.