Forum Discussion
Measure in X-axis
Hello,
I have a 3-4 measures with different values in my table.I want to drag them in bar chart,when i drag them in visualization i am unable to see the measure name in x-axis.
can anyone help me how can i show the measures name in x-axis or other form which can help me...Thanks in advance!!
Hi deepakkhairnar,
Currently, measures can be dragged to value or tooltips field, but can’t be dragged to legend or X-axis field in a bar chart.
Regards,
Jimmy Tao
3 Replies
In general, to use a measure in that way, you need to use the Disconnected Table Trick as this article demonstrates: https://community.powerbi.com/t5/Community-Blog/Solving-Attendance-with-the-Disconnected-Table-Trick/ba-p/279563
Greg, your solution for using a Disconnected Table is great. My issue is that I want to put a numeric value measure on the X-axis of a line chart. Obviously, I can't create a Disconnected table with thousands of dynamic values. Do you know how to deal with this kind of problem? Thanks!
Hi deepakkhairnar,
Currently, measures can be dragged to value or tooltips field, but can’t be dragged to legend or X-axis field in a bar chart.
Regards,
Jimmy Tao
