Forum Discussion
Two Attribute Fields From Same Table in a Table Vis _ Second Attribute is Blank
- 7 months ago
v-pnaroju-msft
I really think there is some kind of corruption in the old workbook.
I created a new workbook
I opened each table in the old in Power Query >> Advanced Editor
I copied
I went to the new workbook >> added a new blank query >> opened in Advanced Editor >> pasted in the query.
I updated anywhere where I changed names and continued until there were no errors in each of the queries.
I added the dimension table for Accounts based on the Bronze Table
I added the relationship from dim Accounts to the 3 fact tablesI added a table visual to to 3 different sheets and added the columns from the different fact tables
and added the Accounts as a slicer on each sheet.
Everything works exactly as expected so Accounts and Inventory is now in all tables.
I added all other queries (39) and tested at each step
Everything is working as expected except 1 measure because we have 75 rows missing unique id's in data coming from Snowflake.Thanks,
w
Hi tecumseh,
Thank you for the update and for sharing the details.
We are pleased to know that everything is functioning exactly as expected. Please continue to utilise the Microsoft Fabric community for any further queries.
Thank you.