Line Graph

[Anonymous]

I would like to create line graph by showing Year/Month on x-axis. I tried different options ,but could not figure it out. Any suggestions how to acheive it?

[selimovd]

Hey @Anonymous ,

there is year and month on the x-axis. How do you want it to look like?

Also please share a screenshot of your hierarchy that you are using for the visual. If you put year and then month name you should get the result.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[Pragati11 · Accepted solution]

Hi @Anonymous ,

Quick way will be something like below:

1. Create a chart moving your date hierarchy on x-axis and keeping just Month & Year in the hierarchy.
2. On the chart drill down to the lowest hierarchy as shown below in the chart:

Once you click on drill-down you get month-year on the x-axis:

Thanks,

Pragati