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.

     

     

ahmedoye's avatar
ahmedoye
Responsive Resident
1 year ago

Slicers are designed to filter by default and can't filter. The other option you have to use that is close to your type of slicer is Tree Map. With some careful formatting you can have something close.

 

  1. Put the data category in Category field
  2. Add the category again to Values and set the summary it to DISTINCTCOUNT
  3. Change the Edit Interactions to Highlight
  4. Format the Treemap to look as close as possible to what you can use.

If you believe this is useful and can solve the challenge for you, kindly mark this as solution so any other persons with similar issues can find it useful.

 

 

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.