Forum Discussion

lovishsood1's avatar
lovishsood1
Icon for Resolver I rankResolver I
2 years ago

Highlight news rows added based on Date

Hello Everyone,   I have a table in which data is being stored DATE-wise.   I have taken a MATRIX visual and date slicer. I want to highlight new rows added based on slicer selection. For examp...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
bolfri's avatar
bolfri
Icon for Solution Sage rankSolution Sage
2 years ago

Hi, can you share some sample data to work with? 🙂

  • lovishsood1's avatar
    lovishsood1
    Icon for Resolver I rankResolver I
    2 years ago
    YearValueUpdatedFromDateCountryAbrv
    20094.203-01-2024LU
    200930.903-01-2024TR
    20092.903-01-2024UK
    2010403-01-2024AT
    20101.903-01-2024BE
    20105.703-01-2024EU
    202015.326-01-2024AL
    20203.226-01-2024SK
    202021.926-01-2024TR
    2009226-01-2024LU

     

    Above sample contains duplicate as well as new data based on DATE.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi lovishsood1 

       

      You can try this measure

      Tooltip_color_Goal-1 = 
var minDate = CALCULATE(Min('Goal 1'[UpdatedFromDate]),ALLSELECTED('Goal 1'[UpdatedFromDate]))
var maxDate = CALCULATE(MAX('Goal 1'[UpdatedFromDate]),ALLSELECTED('Goal 1'[UpdatedFromDate]))
var minValue = CALCULATE(MAX('Goal 1'[Value]),'Goal 1'[UpdatedFromDate]=minDate)
var maxValue = CALCULATE(MAX('Goal 1'[Value]),'Goal 1'[UpdatedFromDate]=maxDate)
var updatedDate = SELECTEDVALUE('Goal 1'[UpdatedFromDate])
var maxSlicerDate = CALCULATE(MAX('Goal 1'[UpdatedFromDate]),ALL('Goal 1'))
RETURN
IF(updatedDate<maxSlicerDate,
IF(minDate=maxDate,0,
IF(minValue=maxValue,0,1)),
1)

       

      Best Regards,
      Jing
      If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

      • lovishsood1's avatar
        lovishsood1
        Icon for Resolver I rankResolver I
        2 years ago

        Nope, It's not making any impact on it.

         

        I think, it is because you have used SELECTEDVALUE function which is not applicable on BETWEEN Slicer.