Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
I am trying to create a table, Item Master, that will contain data about Items. Most of the data comes from the AR_Inventory table, with an additional two columns coming from the Vendor table. Unfortunately, after adding columns to the "Table" visualization, I only see those that have a relationship. I want to show all the data from AR_Inventory with even empty fields for Vendor where there is no data.
Solved! Go to Solution.
Thanks. I solved it in a different way. I added a field from the intermediate table (ARINVT_VENDORS) to the visualization and it solved the problem.
Show items with no data - created a crossjoin in my visualization.
@PKPK90 , Based on what I got. Create a measure with +0 and use
or use the option "Show item with no data"
Thanks. I solved it in a different way. I added a field from the intermediate table (ARINVT_VENDORS) to the visualization and it solved the problem.
Show items with no data - created a crossjoin in my visualization.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
118 | |
81 | |
48 | |
37 | |
27 |
User | Count |
---|---|
185 | |
73 | |
73 | |
50 | |
42 |