Customer Data compare to country average

[SylvainHG]

Dear all, 

I've a Report view that i want to improve to compare average performance of 1 customer compare to the average of all the customers from the same country. Today i use a Matrix for the average of the country and Cards for each value i want to compare.

Is it possible to use Gauge visual? Like performance of the customer as Value and country performance as Target Value? or ... do you have any suggestions to make my report more dynamic?

Thanks 🙂

[v-xinruzhu-msft · Accepted solution]

Hi,

Thanks for the solution @amitchandak  provided, and i want to offer some more information for user to refer to .

hello @SylvainHG , based on your description, you can consider to the following options.

1.You can use the the  Gauge, just put the performance of the customer to the value, and put the country performance to the targer value. You can refer to the following link about the visual.

Radial gauge charts in Power BI - Power BI | Microsoft Learn

2.You can also consider to use KPI visual, it can display the difference, and more clear, you can put the custmer performance to the value, then put the country performance to the target visual, you can then add the trend ,such as month or other, you can refer to the following link about the visual.

Key Performance Indicator (KPI) visuals - Power BI | Microsoft Learn

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@SylvainHG , Assume you are using a measure M1, Try measure like

Sumx( Values(Table[Customer]),  calculate( [M1], filter(allselected(Table),  Table[Country] = max(Table[Country]) )) )

[SylvainHG]

Hi @amitchandak,

Right now i don't use a specific measure. I just have a table with all details and i get mostly all the calculations frow the visuals used in PowerBi