Pivot table multi-column table

[Khomotjo]

Good Morning Everyone,

I have data that summarises orders for a warehouse but it is at an ordeline level. I want to filter out all the orders where one or more order lines should not be picked , i.e where the pick coloumn says "no". The output should be a table to show  only the orders that should be picked in the orderlines i.e only orders where all the orderlines have pick =yes.

[v-pnaroju-msft]

Hi Khomotjo,

We are following up to see if your query has been resolved. Should you have identified a solution, we kindly request you to share it with the community to assist others facing similar issues.

If our response was helpful, please mark it as the accepted solution and provide kudos, as this helps the broader community.

Thank you.

[Ashish_Excel]

Hi,

Share data in a format that can be pasted in an MS Excel file.  Show the expected result clearly.

[v-pnaroju-msft]

Hi Khomotjo,

We wanted to check in regarding your query, as we have not heard back from you. If you have resolved the issue, sharing the solution with the community would be greatly appreciated and could help others encountering similar challenges.

If you found our response useful, kindly mark it as the accepted solution and provide kudos to guide other members.

Thank you.

[v-pnaroju-msft]

Hi Khomotjo,

We have not received a response from you regarding the query and were following up to check if you have found a resolution. If you have identified a solution, we kindly request you to share it with the community, as it may be helpful to others facing a similar issue.

If you find the response helpful, please mark it as the accepted solution and provide kudos, as this will help other members with similar queries.

Thank you.

[v-pnaroju-msft · Accepted solution]

Thankyou, @Cookistador, for your response.

Hi @Khomotjo,

We appreciate your inquiry on the Microsoft Fabric Community Forum.

Please find attached the screenshot and the PBIX file, which may assist you in resolving the issue:

If you find our response helpful, kindly mark it as the accepted solution and provide kudos. This will help other community members who may have similar queries.

Should you have any further questions, please feel free to reach out to the Microsoft Fabric Community.

Thank you.

[Khomotjo]

Thanks @Cookistador  

If you look at the data you will see that an order has multiple order lines  some  of the lines can be picked and others cannot be picked. I want to exclude an order from the table if 1 or more lines cannot be picked.

I want to do this  on the data so I can  write it out into a sharepoint list to share with the warehouse

[Cookistador]

Hello @Khomotjo 

Do you want to apply that at the visual level (only on one table) or a whole page ?

To apply slicler on the visual or the page, click on the visual and in the filter tab, you just have to drag and drop the filed on which you need to apply a filter

If I drag and drop it at the visual level:

Then you just have to select Yes

If you do not see this filter panne, you have to click on view and click on Filters

Now if you want to exclude this value for all reports you will build and know you will never have to make an analysis for Pick = No, the best practice is to do it in power query and exclude this value from your dataset