Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
So in a "normal" data model you'd have something like this:
Subcategory -> Category -> Group
Which is easy to deal with.
But how do you display the data in a clean fashion (meaning no blank rows in a matrix) when you have a situation like this:
Subcategory -> Category -> Group
and
Subcategory -> Group
In my DimCategory table, there are instances where the Category is null (and situations where it is not), but when I drop the data into a matrix visual (along with a SUM measure), it looks like this:
But I want it to look like this:
And then for situations where are 3 levels are needed - display all 3.
I know the Italians over at DAX patterns did something similar - but their example doesn't deal with null categories in the middle of a hierarchy. Only with various levels of depth.
Has anyone dealt with something like this before?
Solved! Go to Solution.
Hi,
In the filter pane, just apply a condition on the SUM measure of non blanks.
Hi,
In the filter pane, just apply a condition on the SUM measure of non blanks.
It's the same thing. Let go of the notion of Subcategory -> Category -> Group and change your thinking to Level 1 -> Level 2 -> Level 3 (optional)
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
144 | |
75 | |
64 | |
52 | |
47 |
User | Count |
---|---|
219 | |
89 | |
76 | |
67 | |
60 |