Ideas for structuring a basic graph

[RichOB]

Hi, I looking for ideas for how to structure/visualize this data. I want to show in a graph the highest number of incidents per Location for each quarter. Something like this:

Incident Type	Location	Date	Financial Quarter
Missing person	Glasgow	01/04/2024	Q1
Missing person	Glasgow	01/04/2024	Q1
Missing person	Edinburgh	01/04/2024	Q1
Missing person	Manchester	01/08/2024	Q2
Missing person	Manchester	01/08/2024	Q2
Missing person	Manchester	01/08/2024	Q2
Missing person	Glasgow	01/11/2024	Q3
Missing person	Glasgow	01/11/2024	Q3
Missing person	Edinburgh	01/11/2024	Q3

Any ideas are welcome, thanks in advance!

[PijushRoy · Accepted solution]

Hi @RichOB 

As per your data, please find the solution. Download PBIX file from attachment
Use Drill Up & Down if needed

[Idrissshatila]

Hello @RichOB ,

you can add the quarters as legend, and put in x-axis the location and show the count of incidents.