Forum Discussion
Remove / Hide field from chart during drill down
Hi,
Chart-Line & Clustered Column Chart
X axis : month, week,date {3 fields are present to create hierarchy}
Y axis : Amount, Avg price{2 measures are present, these 2 bars are side to side}
Line y axis :A line field is present
Question- I want to remove or hide the avg price measure when chart is drilldowned to week or date level. How can I do this?
Thanks in advance!!
2 Replies
- lbendlin
Super User
Learn about ISINSCOPE. Return BLANK() in the measure when week or date is in scope.
ExcludeWeekLevelHierarchy =
SWITCH(
TRUE(),
ISINSCOPE('month'[month]), SUM('Amount'[Amount]),
ISINSCOPE('week'[week]), BLANK()
)
