matrix table

2 Topics

How to create drill-down matrix hierarchy with pre-aggregated data without double-counting?
I have a pre-aggregated dataset from an agency where each hierarchy level has its own row with pre-calculated values: Category Total = 158,244 Sub-category = 45,000 Brand = 11,804 SKU = 350 The dataset also contains multiple periods (Q1, Q2, Q3, Q4, YTD, MAT) and regions — each combination of Product x Period x Region has its own row. Leaf nodes (SKU level) sum up correctly to parent values. What is the best approach to enable drill-down hierarchy in Power BI matrix with this data structure, without double-counting?
Solved
MayaBackovic
4 months ago Place Report Server
4KViews
0likes
6Comments
Matrix Table format error in Power BI server after May 2024 update
Hi Community, I am having issues on the Matrix Table format after updating to May 2024. I have tons of reports with the matrix table format, and after updating the report in May 2024 Server, the Matrix table's format is distorted. The "Stepped layout" was replaced in the new update. I tried to use the Tabular format, but problem still exists. Need your help please. See below snipshot. Thank you for your help.
Solved
Jeff_PowerBI
1 year ago Place Report Server
1.4KViews
0likes
3Comments