Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
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.
User | Count |
---|---|
121 | |
72 | |
71 | |
57 | |
50 |
User | Count |
---|---|
167 | |
83 | |
68 | |
65 | |
55 |