Forum Discussion

vjnvinod's avatar
vjnvinod
Impactful Individual
1 year ago
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...
Need Help
Show and Tell
  • danextian's avatar
    danextian
    1 year ago

    Your measure is probably returning zero. Can you try if([measure]<>0, [measure]) as the custom label.

     

     

danextian's avatar
danextian
Super User
1 year ago

Hi vjnvinod 

 

What we're doing is a workaround which can means we lose some features in favor of the others. No selecting any category should select all.

 

Your data label's display units is set to millions so a very small value relative to others will make it appear zero. You can increase the decimal units or use a custom label. Sample DAX below.

 

Custom Label =
VAR SafeLog =
    IFERROR ( ABS ( INT ( LOG ( ABS ( [Total Revenue] ), 1000 ) ) ), 0 )
VAR dp = 1
RETURN
    IF (
        ABS ( [my measure] ) < 1000,
        FORMAT ( [my measure], "#,#" ),
        ROUND ( DIVIDE ( [my measure], 1000 ^ SafeLog ), dp )
            & SWITCH ( Safelog, 1, "K", 2, "M", 3, "bn", 4, "tn" ) & ")"
    )

 

vjnvinod's avatar
vjnvinod
Impactful Individual
1 year ago

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
  • danextian's avatar
    danextian
    Super User
    1 year ago

    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.

    • vjnvinod's avatar
      vjnvinod
      Impactful Individual
      1 year ago

      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

       

      • danextian's avatar
        danextian
        Super User
        1 year ago

        It is weird that treemap will make them zero. Try using a matrix or a table crossfilterd by a treemap to check  if they return zero