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...
ExcludeWeekLevelHierarchy =
SWITCH(
TRUE(),
ISINSCOPE('month'[month]), SUM('Amount'[Amount]),
ISINSCOPE('week'[week]), BLANK()
)