Creating comparative visualisations

[Anonymous]

Hi

I've created some visualisation on some UK sales data for a training course I'm devising:

The data this is based on looks like this:

The above page has a filter that excludes all rows with "Refunded" = "Y" or "YES"

So far, so good but I want to create some graphs showing comparative data such as: 

* Refunds number of refunds as a % of total sales by store
* Average discounts / store
* Cost of discounts/store
* Discounts as % of net sales"

I'm not sure how to start - any advice?

Query is at https://1drv.ms/u/s!AmxJyApgEAcYgo9X_LCL4h3bDmcPng

Thanks!

Thanks!

[v-yuezhe-msft]

@Anonymous,

Could you please post the logic you use to calculate the following metrics? You can also post expected result based on the sample data in the PBIX file.

* Refunds number of refunds as a % of total sales by store
* Average discounts / store
* Cost of discounts/store
* Discounts as % of net sales"

Regards,
Lydia