visualization of variance

[Anonymous]

hi

i have the requirement where i need to display the chart with top 5 positive and negative variances with respect to sales in the sates of united states . Is there any way that i can represent top 5 and bottom 5 in one chart?. if not how can i show this?

[TomMartens]

Hey,

it's not totally clear what you are the top 5 and bottom 5 sales in the US, the customer, the orders, the products ...

Basically you can filter for the top 5 and for the bottom 5 union both tables and then use this table to filter the customer, the ordres, the products ...

This is my current thinking (it's just a quick something):

CALCULATE(
	[Total Sales]
	,UNION(
		--this returns the top 5 products
		TOPN(5,VALUES('product table'[product]), [Total Sales], 0)
		,--this returns the bottom 5 products
		TOPN(5,VALUES('product table'[product]), [Total Sales], 1)
	)
)
		

I guess it will be much more easy if you create a pbix with sample data, upload the file to onedrive or dropbox and share the link.

Regards

[Anonymous]

@TomMartens  : thanks for your reply .actually my users needs to see like what is the most performaing sales which is doing business great and bottom 5 states with respect to products where business needs to be more focus on so that they can work on closely on taking certian business decisions . That is the reason if they can see in one chart that would be great else i ok to create two charts with top 5 best performaing sales chart and another one is bottom 5 sales performing chart so that it can be visualized properly for taking more accurate decisions

[TomMartens]

Hey,

please create a pbix with some sample data, upload the file onedrive or dropbox and share the link.

Regards,

Tom