Forum Discussion
Filter tables in report builder
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
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.
3 Replies
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.
Anonymous 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?
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.
