Forum Discussion
Solved
Crossh highliting issue
hi, when i select my slicer i want to cross highlight, but its currently filtering out my visual see below. if i do the edit interaction it will show everything but not highligting what i have se...
Your measure is probably returning zero. Can you try if([measure]<>0, [measure]) as the custom label.
danextian values are indeed in M, see below
but when i select the tree map, in this case Transco, other 2 items goes 0
my measure
Actuals =
IF(
ISBLANK(
CALCULATE(SUM('GroupOPEXCAPEX'[Value]), 'GroupOPEXCAPEX'[Actual/Budget] = "Actuals")
),
0, // Return 0 if blank
CALCULATE(SUM('GroupOPEXCAPEX'[Value]), 'GroupOPEXCAPEX'[Actual/Budget] = "Actuals") // Otherwise, return the sum
)
YTD Budget =
VAR CurrentMonth = CALCULATE(
MAX('GroupOPEXCAPEX'[DateColumn]),
GroupOPEXCAPEX[Actual/Budget] = "Actuals",
'GroupOPEXCAPEX'[Value] > 0,
ALL(GroupOPEXCAPEX)
)
VAR FilteredBudget =
CALCULATE(
[Budget],
'GroupOPEXCAPEX'[DateColumn] <= CurrentMonth,
YEAR('GroupOPEXCAPEX'[DateColumn]) = YEAR(CurrentMonth),
MONTH('GroupOPEXCAPEX'[DateColumn]) <= MONTH(CurrentMonth) // Filter for current and prior months of this year
)
RETURN FilteredBudget
What values do you expect for those? Unless they're blank like in the screenshot in my previous reply, data labels will not appear. Also, check for decimals.
there are values and bigger values in millions, but Treemap selection is making them 0, that is the problem statement
question is , why is it returning 0, when the values are big and in millions like in my previous screenshot