Forum Discussion
Use Measure in x-axis
Hi,
While a measure cannot be used as the X-axis of a visual, it will help if you show your data and your expected result. May be someone can suggest an alternative.
Hi,
I am having a similar difficulty in that I am trying to create a line graph with a measure on the x-axis. I've seen the suggestions to use calculated columns instead but don't think that will work for my example.
Attached is a simplified example of what I am trying to accomplish. On the tab, "Original" is shown a table of what I am trying to graph as well as a graph using R instead of Power BI's native line graph (as an aside, the reason I am not wanting to use the R/Python plotting capabilities is that for the amount of data i am working with, it takes a while for the graph to refresh each time i change the filters). One can think of it as ten years of profit from 3 different companies. I want to allow the user the select a single company, two companies, or all three, and then dynamically rank the 10 years of profit and graph them. Since profit is on the x-axis and it's range changes dependant on the filter sittings i'm not sure how to avoid using a measure.
https://www.dropbox.com/s/9g64rnk2e03xklm/Power%20BI%20proof%20of%20concept%20v2.pbix?dl=0
Does anyone have suggestions?
Thanks!