Forum Discussion

IF's avatar
IF
Icon for Post Prodigy rankPost Prodigy
5 years ago
Solved

synoptic visualization for recent date/time

Hi, I want to use synoptic visualization for the visualization of my data. in my data, the most recent data for each type is: If Drive is 7, I want to see it in red color, for 0 purple and fo...
Need Help
  • MFelix's avatar
    MFelix
    5 years ago

    Hi IF ,

     

    You can create the following measures:

    Drive Value = 
VAR maximumdte =
    MAX ( 'Table'[Date] )
VAR temptable =
    SUMMARIZE (
        FILTER (
            ALL (
                'Table'[Date],
                'Table'[Drive],
                'Table'[Layer],
                'Table'[LC],
                'Table'[Type]
            ),
            'Table'[Date] = maximumdte
                && 'Table'[LC] IN VALUES ( 'Table'[LC] )
        ),
        'Table'[Date],
        'Table'[Drive],
        'Table'[LC],
        'Table'[Type]
    )
RETURN
    SUMX ( temptable, 'Table'[Drive] )

     

    Type Value = 
VAR maximumdte =
    MAX ( 'Table'[Date] )
VAR temptable =
    SUMMARIZE (
        FILTER (
            ALL (
                'Table'[Date],
                'Table'[Drive],
                'Table'[Layer],
                'Table'[LC],
                'Table'[Type]
            ),
            'Table'[Date] = maximumdte
                && 'Table'[LC] IN VALUES ( 'Table'[LC] )
        ),
        'Table'[Date],
        'Table'[Drive],
        'Table'[LC],
        'Table'[Type]
    )
RETURN
    MAXX ( temptable, 'Table'[Type] )

     

    The first measure must be used in the measure and state measures of the synoptic panel the other one is to use on the tooltip:

     

     

IF's avatar
IF
Icon for Post Prodigy rankPost Prodigy
5 years ago

Wonderful. Thanks a lot! Is it possible to consider only the recent data for each type. In this table, the most recent data for types B,C, and D are on the same day. Instead of having a slicer for the date, would it be possible to use only the most recent data for each type? I have a real-time connection and I would like to consider only the latest value for types B,C and D. Thanks in advance.

p.s. in any case I will accept as "accept as solution", but waiting for a reply to select the correct reply. 🙂 

 

MFelix's avatar
MFelix
Icon for Super User rankSuper User
5 years ago

Hi IF ,

 

You can create the following measures:

Drive Value = 
VAR maximumdte =
    MAX ( 'Table'[Date] )
VAR temptable =
    SUMMARIZE (
        FILTER (
            ALL (
                'Table'[Date],
                'Table'[Drive],
                'Table'[Layer],
                'Table'[LC],
                'Table'[Type]
            ),
            'Table'[Date] = maximumdte
                && 'Table'[LC] IN VALUES ( 'Table'[LC] )
        ),
        'Table'[Date],
        'Table'[Drive],
        'Table'[LC],
        'Table'[Type]
    )
RETURN
    SUMX ( temptable, 'Table'[Drive] )

 

Type Value = 
VAR maximumdte =
    MAX ( 'Table'[Date] )
VAR temptable =
    SUMMARIZE (
        FILTER (
            ALL (
                'Table'[Date],
                'Table'[Drive],
                'Table'[Layer],
                'Table'[LC],
                'Table'[Type]
            ),
            'Table'[Date] = maximumdte
                && 'Table'[LC] IN VALUES ( 'Table'[LC] )
        ),
        'Table'[Date],
        'Table'[Drive],
        'Table'[LC],
        'Table'[Type]
    )
RETURN
    MAXX ( temptable, 'Table'[Type] )

 

The first measure must be used in the measure and state measures of the synoptic panel the other one is to use on the tooltip: