cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
GSinghking Member
Member

Map box location latest 24 hours color on circle

Hi. 

I have some locations on my mapbox visualatation. 

here is the accsess token: pk.eyJ1Ijoic2luZ2hjaGFrIiwiYSI6ImNrMWFsaXRmbzI1c3YzbG5pZXBrcjFva3EifQ.Xr1RgAZJ72eG6Lhx5JohTg

This are different (ID) devices that are placed on different locations. 

the devices sends out long and lat values during the day many times. 

But sometimes it dosent

So if the device dont send any location during the last 24 hours, give me red circle on the map.

red skjermbilde.PNG

But if there is long and latitude values coming in then give me green light. 


green skjermbilde.PNG

also i upload sample file. 

Please provide me solution hope you understand. 

If there is no long and lat values last 24 hours and its ''null'' then red light but if there is long and lat values last 24 hours then please green circle


here is sample. 


Please modify solution and give it back to me. 


https://1drv.ms/u/s!Aj1018-Yl8DukQ3uo1S2jNB_CTBf?e=KIqx1K


4 REPLIES 4
GSinghking Member
Member

Re: Map box location latest 24 hours color on circle

anyone?????

Community Support Team
Community Support Team

Re: Map box location latest 24 hours color on circle

Hi @GSinghking ,

It seems like you are testing with third party custom visuals and I think it should more related to visual itself. You can contact to visual designer for further support.

Mapbox help

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI
Highlighted
GSinghking Member
Member

Re: Map box location latest 24 hours color on circle

I need to make some caluclation for it. @v-shex-msft .

No need to contact map box for that. 

Need a measure that checks the 24 hours latest reading, it will show that on the map with red and green color. 

any idea how???

Community Support Team
Community Support Team

Re: Map box location latest 24 hours color on circle

HI @GSinghking ,

Maybe you can try to use following measure to compare between the current date and max date and return result tag:

Measure = 
VAR currDate =
    MAX ( 'Table'[timestamp] )
VAR maxDate =
    MAXX ( ALLSELECTED ( 'Table'[timestamp] ), [timestamp] )
RETURN
    IF ( currDate >= maxDate - 1, "Y", "N" )

I haven't found any option to enable advanced color formatting on custom visuals.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI

Helpful resources

Announcements
Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors