Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
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:
Thank 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.
@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/...
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pan...
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |