Forum Discussion

dogburalHK82's avatar
dogburalHK82
Helper III
2 years ago
Solved

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 P...
expression
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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's avatar
dogburalHK82
Helper III
2 years ago

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?

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.