Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi everyone,
I am trying to follow the official OKviz guide on setting the conditional formating for the visual: https://okviz.com/blog/states-in-custom-visuals/
However, am struggling with understanding all the steps.
Essentially, I would like to create a Green to Red gradient where the the target will be top value on the map, hence dynamically changing.
10% below highest value will be Green, 20% below will be Amber and anything below Red.
Is this something possible to create with the Synoptic Panel? If so, what would the best approach in setting up states and measures?
Thank you in advance.
Solved! Go to Solution.
Hi, @Anonymous
If I understand you correctly, you can directly create three measures then apply them to the 'States' section of 'Fields' panel.
Good =0.9 * [heighest value]
Ok=0.8*[heighest value]
Poor=0*[heighest value]
Then need to set the 'Comparison' of 'State' section in ’Format‘ panel to '>=' and set the color of each state.
Best Regards,
Community Support Team _ Eason
Hi @v-easonf-msft ,
That's exactly what I was looking for! Ended up being such a simple solution, thank you.
Currently trying to figure out a way of using a slider to choose between two external .svg URL maps. Do you know any easy tips with this one?
Thanks
Hi, @Anonymous
If I understand you correctly, you can directly create three measures then apply them to the 'States' section of 'Fields' panel.
Good =0.9 * [heighest value]
Ok=0.8*[heighest value]
Poor=0*[heighest value]
Then need to set the 'Comparison' of 'State' section in ’Format‘ panel to '>=' and set the color of each state.
Best Regards,
Community Support Team _ Eason
User | Count |
---|---|
77 | |
74 | |
42 | |
32 | |
28 |
User | Count |
---|---|
99 | |
92 | |
50 | |
47 | |
46 |