Synoptic Panel not working for States measures

[helenastein]

Hi all!

For a few days I have tried to use the synoptic panel unsuccesfully.

I need to color the following areas according to the percentage of people in it:

The 'Areas_people' table below contains the amount of people now (column 2) and in 30 minutes from now (column 3): 

Area	People_0_minutes	People_30_minutes
1	154	30
2	155	200
3	171	250
4	186	55
3	121	10
4	185	28
2	143	203
1	146	12
2	143	0

I have created the measure "All_intervals" to segment these data and sum up the amount of people in each area for both time periods, which works just fine:

All_intervals = SWITCH([Select_interval], 0, [Pax0], 30, [Pax30])

where 

Select_interval = SELECTEDVALUE(Intervals[Code],1)

and 'Intervals' table is:

Order	Name	Code
1	Now	0
2	+30min	30

Each area has its own capacity, according to table 'Areas_capacities', and I want that each area displays the color that represents how full it is, based on 3 states:

State 1: LOW              < 25% of the area capacity

State 2: MEDIUM        < 75% of the area capacity

State 3: HIGH              More than 100% of the area capacity

Areas_Capacities table:

Area	Capacity
1	270
2	500
3	300
4	600

Following the instructions from okviz blog I understand that my framework must be organized as folows:

In which the measures LOW, MEDIUM and HIGH are calculated measures

1. LOW = 0.25 *[Get_capacities];  MEDIUM= 0.75 *[Get_capacities]; HIGH = 1 *[Get_capacities]

based on Get_capacities measure:

Get_capacities = CALCULATE(SUM(Areas_Capacities[Area]), ALLEXCEPT(Areas_Capacities,Areas_Capacities[Area]))

I end up with no coloring on maps and several repeated entries in States:

Does anyone have any hint on how to make it work?

Any help would be appreciated!

Many thanks in advance!

Helena

[v-easonf-msft]

Hi, @helenastein 

I have not encountered a similar situation but I find something similar in the comments section of this blog.

Using states with Custom Visuals by OKVIZ 

As this custom visual is not published by Microsoft, it hard to confirm that if this is an issue or by design.

You'd better have a contact with the publisher OKViz.

Best Regards,
Community Support Team _ Eason

[helenastein]

Hi @v-easonf-msft !

I had already checked these issues on the blog comments section. I will take a better look on Okviz Github repo!

Thank you for your suggestion and time 🙂

Best regards

Helena