cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
IF
Post Prodigy
Post Prodigy

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:

10-22_3.jpg

If Drive is 7, I want to see it in red color, for 0 purple and for 1 it should be in yellow. The rest should be blue. I also want to see type names as labels or tooltips.

10-22_2.jpg

I played a little bit with the visualization but couldn't find how to make it. Could you help me for it?

The power bi file is available at:https://www.dropbox.com/s/7pa2hs79q0d3wvg/10-22.pbix?dl=0

 

Thanks in advance!

 

1 ACCEPTED SOLUTION
MFelix
Super User III
Super User III

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:

 

MFelix_0-1622110797527.png

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

5 REPLIES 5
v-lionel-msft
Community Support
Community Support

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.

 

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
Super User III
Super User III

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:

MFelix_1-1622043826255.png

 

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:

MFelix_2-1622043990199.png

 

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.

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



IF
Post Prodigy
Post Prodigy

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
Super User III
Super User III

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:

 

MFelix_0-1622110797527.png

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors