How do I plot a line chart without X-axis values?

[Anonymous]

I have the following dataset:

dataset

I would like to plot the following line chart, where the Y-axis is the sum of all values for USE_Percentile10, 20, 30, etc.

I am having trouble because values for X-Axis don't exist. I thought that maybe PowerBI could improvise like Excel by creating an X-Axis but it doesn't seem to have this capability.

Can I do it with the available dataset or do I have to create a new table (like below) with values for the X-Axis?

New Table

[Anonymous]

Can you hide the X-axis on the Format category of the visual ?

[amitchandak]

@Anonymous , Add an index column in the power query and use that on the axis

https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi

[Anonymous]

Hello, amitchandak.

Thanks for the reply.

Your advice doesn't work because I think my diagnostic of the issue is wrong. I think I might have to unpivot the USE_Percentile# columns.

I'll let you know if it works.

Cheers

[Anonymous · Accepted solution]

As you can see, it was a matter of unpivoting the data:

Cheers