Forum Discussion
Different shapes for different data
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: