Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Alignment issue on AXIS for Clustered Bar Chart

Hello All, I am showing Top 5 / Corporate / Bottom 5 of my sales data. Assume that it's a store sales data. Now when I select different visuals my top 5 / Bottom 5 also changes. With these changes...
Need Help
amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous ,While you can not combine visual

 

You can to measure and use in same visual

 

example

City Rank = RANKX(all(Geography[City]),[Sales],,desc,dense)

Top 5  = sumx(filter(VALUES(Geography[City]),[City Rank]<=5),[Sales] )

 

City Rank 1 = RANKX(all(Geography[City]),[Sales],,asc,dense)

Bottom 5  = sumx(filter(VALUES(Geography[City]),[City Rank 1]<=5),[Sales] )

 

or use them togther in a measure

 

Top Bottom 5  = sumx(filter(VALUES(Geography[City]),[City Rank]<=5 || [City Rank 1]<=5),[Sales] )

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi amitchandak

     

    Thanks for your help. I would like to have corporate average in between top 5 and bottom 5 in one measure only. How can I get that?