Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

visualization of variance

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?

Need Help

3 Replies

  • TomMartens's avatar
    TomMartens
    Icon for Super User rankSuper User
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

      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's avatar
        TomMartens
        Icon for Super User rankSuper User
        7 years ago

        Hey,

         

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

         

        Regards,

        Tom