Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
I'm using hexagons to represent how a territorial authority is performing according to a range of indicators. I've managed to get the hexagons to be coloured according to performance via the "States" function. For example, if greater than or equal to 90% colour it blue. I'm trying to get the 'performance' to come up as a Legend. However, if I select Legend I just get the names of each of the territorial authorities and the colour it corresponds to.
How do I switch it to using the "States"?
Hi @EMC .
Not certain what is your expected output. Did you want legend's color is matched with state's color?
If so, you can set the states color first, then enable 'show all' in Data color tab and adjust it to match with States color.
If not, you can share more details about this for further discussion.
Sample file and expected output would help tremendously.
Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
This is what it looks like at the moment. As you can see the legend has the Local Board names and corresponding colours.
I would like the bottom legend to have how the Local Boards are going. E.g., Dark blue = above 90%, etc
Hi @EMC ,
As I previous posted, you can enable 'Show all' options in the 'Data Color' tab and adjust each legend color which is matched with each board color manually.
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
I did "Show all" but that didn't work
I want to be able to change what the words in the legend are. I don't want the State/Local Board names, I want to change them to - "above 90%" etc
Hi @EMC ,
Based on my test, legend name cannot be changed conditionally in this visual. Since this is a custom visual, we cannot change the settings for it by ourselves, perhaps you could try to contact the owner of the custom visual: https://okviz.com/synoptic-panel/
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
@EMC not sure if it is possible but I would recommend checking with the developer since it is a custom visual.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
75 | |
62 | |
51 | |
47 |
User | Count |
---|---|
212 | |
82 | |
61 | |
60 | |
57 |