Cannot add measure to x axis

ElliotK you can't put a measure on an X axis.
You can however use the new field parameter feature to accomplish the user experience you are looking for.
https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters
Please read the doc and watch some related videos and you will be fine 🙂
https://www.youtube.com/watch?v=-nqEv2YXLsU

https://www.youtube.com/watch?v=TufnsAxJsjs

      

Showcase Report – Contoso By SpartaBI

ElliotKmy pleasure 🙂
Check out my showcase report - got some high level stuff there. Sure you will find there a lot of cool ideas. Please give it a thumbs up over there if you liked it 🙂https://community.powerbi.com/t5/Data-Stories-Gallery/SpartaBI-Feat-Contoso-100K/td-p/2449543 

And come follow us 🙂
https://www.linkedin.com/company/spartabi