Forum Discussion
Resolver IIITwo Attribute Fields From Same Table in a Table Vis _ Second Attribute is Blank
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
Community SupportThankyou, GeraldGEmerick and danextian for your responses.
Hi tecumseh,
Thankyou for the update.
Based on my understanding, although Inventory is visible in the Gold table in Power Query, Power BI visuals and slicers operate solely through model relationships and filter context. In the Gold layer, the Account slicer may not propagate filter context correctly due to either an inactive or incorrect relationship, the slicer being sourced from a fact table rather than a dimension table, or a grain mismatch introduced by aggregation in the Gold table, wherein Inventory is no longer unique per Account and consequently evaluates to BLANK. This is the reason Inventory appears in Bronze and Silver (row-level data) but not in Gold (aggregated or reshaped data).
A possible approach is to ensure that the Account slicer originates from a proper dimension table, that the Gold table maintains an active relationship to that dimension with the correct cardinality and cross-filter direction, and that Inventory is either aggregated or modeled as a measure if the Gold table is at a higher grain.
Additionally, please refer to the links below:
Model relationships in Power BI Desktop - Power BI | Microsoft Learn
Understand star schema and the importance for Power BI - Power BI | Microsoft Learn
Work with aggregates (sum, average, and so on) in Power BI - Power BI | Microsoft Learn
We hope the information provided helps to resolve the issue. Should you have any further queries, kindly feel free to contact the Microsoft Fabric community.
Thank you.
Resolver IIIv-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 tables
I 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