I do not want Sum of month number, I just want month number

[sroemer26]

Hey Guys 👋

I am trying to rank two variables on my x axis. 

To do this I have an inner rank and outer rank. 

I have my inner rank all figured out, now my outer rank should be my Month Number, However, right now PowerBI is summing my month Number, How do I get it to not do this?

RANKX , ALLSELECTED , Months , Sort , X Axis , Column , Chart , Month Number

Thanks for your help!

[sroemer26 · Accepted solution]

I figured it out... Thanks somewhat to co pilot. 

[Anonymous]

Hi @sroemer26 ,

Glad to hear you solved the problem yourself and thanks for posting your solution here. Please mark your reply as solution so that more users facing the same problem can find the solution faster, thanks!

Best Regards,
Dino Tao