Want a line chart with my specific way

[shantanugupta]

I am facing a problem in power bi as I would like all my data to be visible without having to use the scroll bar. Attach PowerQC_Shantanu.pbix file.

I made the excel chart look like this.

Want this type of chart in power bi

Data Attached:- Data

Any help??? How to solve this problem?

[v-janeyg-msft · Accepted solution]

Hi, @shantanugupta 

The report can't open due to dataset permissions. I think you can use date column(datereported)as x axis, and turn off the x axis button.

If it doesn’t solve your problem, please feel free to ask me.

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@shantanugupta , I think for that you have to restrict the values or try axis try continuous

[shantanugupta]

1.Can't change axis to continuous. when I change it automatically converts to categorical.

2.Can't restrict the values as I have a filter which changes according to the user.