Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello
I have a list or orders that contains vendor no's and qty or orders from each. My matrix is filtered that it calculated only purchases that contain items, leaving out purchases that are in G/L accounts. However, we have one vendor which should be in this list even if ALL of purchases are in G/L accounts, not items.
I have filtered my matrix so that it leaves out purchases which have item category = empty
How can I have this one vendor to be visible in my list, so that my filtering wouldn't apply to this certain vendor?
br
Matt
probably needs dummy item lines.
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.
If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
Vendor | Item Category | Quantity |
50772 | 20000 | |
90001 | CAT | 7000 |
80003 | DOG | 50000 |
Hi
I think this could be solved with Replacer.ReplaceText and Table.ReplaceValue functions but can't seem to get them right. Appreciate the help. End result should be: if vender number is 50772 then Item Category is "X"
br
Matti
I thought you wanted to display vendor 50772 regardless of what item category is selected/filtered?
I want to display vendors which have item category, with the exception if vendor 50772 which doesn't have item category. So I was thinking to use replace function to replace empty field(s) with X.
Do you plan to use a category slicer? Will your users know to always select "X" on that slicer?