Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
Can't seem to find a good solution to this problem. I have a matrix with three levels of rows. For my test I have called it level1, level2 and level3.
These can be found from two different dimension tables. What I'm curious about is if it is possible to show all level1 items, event when there is no data with related values to it?
I have tried to use the "Show items with no data" function, but this gives me all rows for every hierarchy level, which I do not want.
To better show my issue I'm adding two pictures of my model and my matrix tables, one that includes all my level1 items, but noe values, which is how all are included, then I add level3 items and corresponding value, then some level1 items dissapear naturally because they are empty.
Any suggestions on how to include all level1 items?
I have attached my sample file here: https://www.udrop.com/5yhX/showfirsthierarchy.pbix
Thanks!
Solved! Go to Solution.
One possible workaround is to force level 1 to be non-blank by adding zero at that level.
SumVal = SUM ( 'Fact'[Value] ) + IF ( ISINSCOPE ( dim2[level2] ), BLANK(), 0 )
This means that if we are at level 2 (or below), then we keep it blank but use zero for the higher levels (level 1).
If you don't like the zeros instead of blank, you can change the measure display format to show nothing or something else for a zero result.
One possible workaround is to force level 1 to be non-blank by adding zero at that level.
SumVal = SUM ( 'Fact'[Value] ) + IF ( ISINSCOPE ( dim2[level2] ), BLANK(), 0 )
This means that if we are at level 2 (or below), then we keep it blank but use zero for the higher levels (level 1).
If you don't like the zeros instead of blank, you can change the measure display format to show nothing or something else for a zero result.
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
72 | |
67 | |
51 | |
38 | |
26 |
User | Count |
---|---|
88 | |
52 | |
45 | |
39 | |
38 |