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.

     

     

vjnvinod's avatar
vjnvinod
Impactful Individual
1 year ago

ahmedoye   danextian  thanks, there are 2 challenges again,

1) i loose Select all option

2) when i use tree visual, for example when i selected ADDC,  for my other 2  data label values are showing 0, see below screenshot

 

 

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