Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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.
User | Count |
---|---|
84 | |
77 | |
64 | |
51 | |
46 |
User | Count |
---|---|
101 | |
42 | |
41 | |
39 | |
36 |