Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
94 | |
74 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |