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,
Matrix visual as shown below , displays the sub level details even if there is only one sub level.
I want to hide the sub level if there is only one sub level, in this case to display only upto "Provincial" level , coz values is same in only one sub level i.e. "ADP (Provincial)"
Any Help ?
Solved! Go to Solution.
Hi @Arshadjehan ,
Sorry for misunderstanding your request. Here we cannot filter the matrix directly, we can create measure to work on it.
sum of be =
VAR dis =
DISTINCTCOUNT ( 'Table'[sub2] )
var be = SUM('Table'[BE])
var a = IF(dis = 1
&& ISINSCOPE ( 'Table'[sub2] )
&& OR (
SUM ( 'Table'[Release] )
= CALCULATE ( SUM ( 'Table'[Release] ), ALL ( 'Table'[sub2] ) ),
SUM ( 'Table'[Release] ) = 0),TRUE())
var b =
IF(dis = 1
&& ISINSCOPE ( 'Table'[sub2] )
&& OR (
be
= CALCULATE ( be, ALL ( 'Table'[sub2] ) ),
be = 0),TRUE())
RETURN
IF (
a&&b,
BLANK(),be
)
For more details, please check the pbix as attached.
Hi @Arshadjehan ,
Sorry for misunderstanding your request. Here we cannot filter the matrix directly, we can create measure to work on it.
sum of be =
VAR dis =
DISTINCTCOUNT ( 'Table'[sub2] )
var be = SUM('Table'[BE])
var a = IF(dis = 1
&& ISINSCOPE ( 'Table'[sub2] )
&& OR (
SUM ( 'Table'[Release] )
= CALCULATE ( SUM ( 'Table'[Release] ), ALL ( 'Table'[sub2] ) ),
SUM ( 'Table'[Release] ) = 0),TRUE())
var b =
IF(dis = 1
&& ISINSCOPE ( 'Table'[sub2] )
&& OR (
be
= CALCULATE ( be, ALL ( 'Table'[sub2] ) ),
be = 0),TRUE())
RETURN
IF (
a&&b,
BLANK(),be
)
For more details, please check the pbix as attached.
Hi @Arshadjehan ,
Please enable the option "show items with no data " for the rows in your matrix visual.
@v-frfei-msft I probably couldnt make you understand what I want!
I want to hide the sub level, if there is only one sub level, and to show as parent level only.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
72 | |
37 | |
31 | |
26 |
User | Count |
---|---|
95 | |
50 | |
43 | |
40 | |
35 |