How to get Competetor Sales for Store

[Kcponakala]

Hi Everyone,

I have requirement like

1. to get competetor sales for the selected store (we have a role on store)

2. to show both Slected store sales and competetor stores sales and highlight Own store sales (bubble chart kind of representation)

3. Sales exclude my sales

xlsx file

pbix file

Please help me on this ..

Thanks in advance,

Kalyan

[amitchandak]

@Kcponakala , You can create common store dimension and analyze data against it