Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
94 | |
86 | |
78 | |
70 | |
63 |
User | Count |
---|---|
114 | |
101 | |
97 | |
66 | |
59 |