Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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

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

 

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

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

     

     

    Cheers

4 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      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's avatar
        Anonymous
        Not applicable
        4 years ago

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

         

         

        Cheers

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

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