Measure in X-axis

[deepakkhairnar]

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!!

[v-yuta-msft · Accepted solution]

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

[Greg_Deckler]

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...

[greatztbi]

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!