Power BI - Queensland Crimes What-If

GilbertQ — Wed, 30 Aug 2017 06:02:14 GMT

I have used the data that is available from the Queensland Police Website and put it into Power BI.

Then what I did was to create a What-If Parameter which is based on how many years back you want to go, and then compare the Crime from the What-If Parameter until today.

So for example you could compare what the Crime was like 10 years ago, comparing it to today and then getting a % change. Almost all the visuals use the % change except for the Line Chart which show the total crimes. This is so that as the report consumer you can quickly see how the crime has changed.

I have also put in a Slicer so that if you are from Queensland or want to filter a particular area you can see how crime has changed over time by using the What-If Parameter.

There are some really interesting details based on different area's as well as on different years. I do hope that people will find this as great insights into how you can leverage data and using the What-If parameter.

eyJrIjoiYjM4ZGViODUtZDJmZi00NGI4LTkzOWUtNjQ3NzI4MmViN2Y1IiwidCI6ImQ3MGI0ZDU1LWE1OTItNDVmMi05OWYzLTI5OWFlNWVlN2FkZSJ9

topic Power BI - Queensland Crimes What-If in Data Stories Gallery

Power BI - Queensland Crimes What-If