Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Wondering if it's possible to hide specific values once a certain degree of expansion has been reached in matrix table?
Example:
Value X can be expanded as follows:
Country/State/City/Street
Is it possible to only show Value X up until State? So if user expands past state, all they would see is blank for City and the Street?
Thanks.
Solved! Go to Solution.
@m_roussakis OK, try the reverse:
Measure =
SWITCH(TRUE(),
ISINSCOPE('Table'[City]) || ISINSCOPE('Table'[Street]),BLANK(),
[some measure]
)
If it still doesn't work, post some sample data and I can try mocking it up.
Only effect I have noticed is the total is blank on the matrix table for this value.
@m_roussakis Maybe.
Measure =
SWITCH(TRUE(),
ISINSCOPE('Table'[Country]) || ISINSCOPE('Table'[State]),[Some measure],
BLANK()
)
@Greg_Deckler I tried this out and it still doesn't hide the intended levels in the table ....
@m_roussakis OK, try the reverse:
Measure =
SWITCH(TRUE(),
ISINSCOPE('Table'[City]) || ISINSCOPE('Table'[Street]),BLANK(),
[some measure]
)
If it still doesn't work, post some sample data and I can try mocking it up.
User | Count |
---|---|
79 | |
76 | |
62 | |
60 | |
48 |
User | Count |
---|---|
109 | |
95 | |
86 | |
79 | |
61 |