The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have the following dataset in following form:
Level 1 Level 2 Level 3 some value
Gross Profit Revenue A Product A 2
Gross Profit Revenue B Product A 3
EBIT EBIT A Product A 4
EBIT EBIT B Product C 5
EBIT EBIT B Product B 6
I am trying to create simple matrix table that has expandable rows based on level hierarchy. Somehow when I just put those three columns Leve 1, Level 2, Level 3 I cant get this to work properly:
Any idea what might be wrong and why im getting Level 1 value multiple times one for each level 2 value below, instead of SINGLE level 1 that woudl expand onto level 2 values and so on?
Hi @atpbi10
The result bellow is correct according to the sample you shared, I cannot reproduce that behavior with your sample data, please provide a sample file with that behavior, thanks. Also, you can change the data type to text and test again.
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Your screenshot doesn't match your sample data. Please show expected outcome based on the provided sample data (or provide more comprehensive sample data).