Graph needs in qaurter for 4 years

[Vashisht106]

HI,

I have a data which starts from 2015 till 2018, where i am trying to make a line chart showing trend from 2015 to 2018.

But we need this line chart on quarter basis, so we should have 16 quarters in graph, but i am not sure how to show it.

Please assist on the same.

Thanks

[v-danhe-msft]

Hi @Vashisht106,

Based on my test, you can refer to below steps:

1.I have entered some sample data to test your problem in below picture.

2.Turn on the Show dates as a hierarchy feature, it may require restarting Power BI desktop. Create a Line chart visual and add the [Year], [Quarter], and [Random] fields. Modify the X-Axis type from the “Continuous” to “Categorical”. Now you can see the result.

You can also download the PBIX file to have a view.

https://www.dropbox.com/s/zlht1hktz4r7kgi/Graph%20needs%20in%20qaurter%20for%204%20years%20.pbix?dl=...

Regards,

Daniel He

[Vashisht106]

Hi,

Thanks for taking time and looking at it but this didnt serve my purpose...i tired to create a same table and then link it with my data.

Taking values from my original data and date from new table but it doesnt show any thing...i dont know if i can upload my sample data here...

[v-danhe-msft]

Hi @Vashisht106,

To find the cause as soon as possible, I would suggest you share pbix file if possible. If the report does contain sensitive data, please upload your report to your OneDrive and send the link to me via private message.

Regards,

Daniel He

[Vashisht106]

HI,

Here is the file link i have saved in dropbox...please let me know if you can view it with naming convention "Expmnt_BI"

https://www.dropbox.com/home

[v-danhe-msft]

Hi @Vashisht106,

From this link, I could not get your file, could you please check your file link?

Regards,

Daniel He

[Vashisht106]

Not sure if you can view....can i have email id....dropbox gives me option to share folder with a email id