Forum Discussion

IF's avatar
IF
Post 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:

     

     

v-lionel-msft's avatar
v-lionel-msft
Community Support
5 years ago

Hi IF ,

 

I'm not sure if this custom visual can add a conditional formula to the data color, if so, please create the following measure.

Data Color = 
SWITCH(
    MAX([Drive]),
    7, "Red",
    0, "Purple",
    1, "yellow",
    "Blue"
)

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

IF's avatar
IF
Post Prodigy
5 years ago

Hi,

I tried but couldn't have the result. The file is at dropbox. Could you try since I may do some mistakes?

Best

  • MFelix's avatar
    MFelix
    Super User
    5 years ago

    Hi IF ,

     

    In the usage of synoptic panel you have to pay attention that each area of your chart will be mapped to an area, in this case you need to make the match between the areas and your LC:

     

    Now you need to setup the synopic panel in the following way:

    Category: LC

    Measure: Min of drive

    States Measure: Min of drive

    Turn on states:

    Comparision =

    State A Purple 0

    State B Red 7

    State C Yellow 1

     

    See result below and in attach PBIX. Also adding the SVG file:

     

    Be aware that I'm using the MIN value but this can be change to a measure that you need you just need then to adjust the states to follow that measure.

     

    • IF's avatar
      IF
      Post 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
        Super 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: