i I have a report where i need the following not to be shown.
Background
Under BIlling I have 4 options Booking , Corporate , Portal sales , Reception sales and under Ship ID i have various ships 6 , 5 , 26 etc etc
What I need
I want to the report to show me billing type is not corporate and under the following ships IDs 6, 35,28, 32, 42 , 5 or 62. When i use the page filter option as shown in the image below . the Ship IDs mentioned aboved is also removed from the report but what i need is only for the CORPORATE to be removed from those ships IDs.
Should I use a SUMIF or IF formula ? Not sure how to go about it
Can someone please help me with this
@Anonymous not sure I understood your request correctly. If you filtered on corporate why you are also filtering on "ship id". Did you tried using not to filter "ship id"
as best practice please share sample data and expected result to get your answer quickly.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@Anonymous not sure I understood your request correctly. If you filtered on corporate why you are also filtering on "ship id". Did you tried using not to filter "ship id"
as best practice please share sample data and expected result to get your answer quickly.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Hi Parry @parry2k
Well my question is I want to know how to get a report which shows all data that is not billing type "coroporate" under the following ships ids of 6, 35,28, 32, 42 , 5 or 62.
Because under these ships there are other billing types such as portal sales, reception and booking which I need the data to be visible.
Hope I am a bit clear now
Helpful resources
Microsoft Fabric Learn Together
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Power BI Monthly Update - April 2024
Check out the April 2024 Power BI update to learn about new features.
Fabric Community Update - April 2024
Find out what's new and trending in the Fabric Community.
