Forum Discussion
Different shapes for different data
Hi, everyone.
I've created a simple database system for hazard information in my workspace and now i need to create reports to use as hazard maps.
In my system I have five color coded types of hazard and three degrees of it: small, medium and large. Since tje Access report tool seemed to be too complicated for me to achieve that, is it possible to make shapes which formatting represent the degree of risk (a small circle for small risk and so on) and it's corresponding color in Power BI?
Thanks in advance!
3 Replies
WilliamAzevedo , You need to associate some value, then in scatter visual, you can use size. for color, you can use measure based conditional formatting
How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/1682539
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pane-66e0afcb15f3Thank you for your reply amitchandak!
I have to admit I'm stuck in the value I should associate. Since in this case I'm not dealing with numbers, but with categories, I really don't know where to begin from. Here's what would be my table:
Unidade (Location) Risco (Risk) Tipo (Type of Risk) Grau (Degree) ALMOXARIFADO Arranjo físico inadequado Acidente Pequeno ALMOXARIFADO Eletricidade Acidente Grande ALMOXARIFADO Piso irregular Acidente Pequeno ALMOXARIFADO Fungos Biológico Médio ALMOXARIFADO Calor Físico Médio Booster Barreiras Eletricidade Acidente Grande Booster Barreiras Bactérias Biológico Pequeno Booster Barreiras Fungos Biológico Pequeno Booster Barreiras Ruído Físico Grande Booster Barreiras Poeira Químico Grande BOOSTER GALHARDO Ferramentas inadequdas ou defeituosas Acidente Pequeno BOOSTER GALHARDO Vírus Biológico Médio BOOSTER GALHARDO Iluminação inadequada Ergonômico Médio BOOSTER GALHARDO Calor Físico Grande BOOSTER GALHARDO Calor Físico Pequeno As you can see, there are no numbers, I will use a segmenter to set the Location and then i need the circles (preferably) to describe the risks by color (Type of Risk) and size (Degree) of that Location.
Hi.
If eventually it can help anyone else, I think I achieved the report design I needed.
As said before, I have 5 Types of Risk (Tipo), each type with 3 Degrees (Grau). I inserted one Pie visual to each risk possibility (total of 15) and created measures filtering risks by Degree (Risco Grande, Risco Médio and Risco Pequeno). Then I used the Risk (Risco) in the Legend field of the visual and the Risk Degree measure in Values, filtering by Type of Risk. Finally, inserted my slicers and it's working so far! I believe it's not as elegant as it could be, or even as I would like it to be (I have to set the Risk color manually by slice), but, it fullfills it's purpose.
Thank you amitchandak for the input. Your suggestion was the spark I needed to do this!
Here's some screenshots of the result:
