Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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.
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.
@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?
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.