This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowThe Fabric community is now in read-only for platform upgrade. Learn more
Hello everyone
I'm trying to create a temporal graph, of lines, with the same variable but in two different years. That is, a single variable, and on the x-axis only the months, and then paint two lines one of each year. Something like the example where red is one year and blue another, I guess creating a measure
I have managed to do something similar, but if I put months on the x axis I see the accumulated of the month, and the idea is to represent in the lines the daily data but in the x axis only the months, I do not know if it is possible.
@Syndicate_Admin , You can use the year as legend and use month on axis
but that will not give a continuous line.
It is not expected. I was thinking about creating a measure with the data variable and having it filter out only the year I need. Any ideas?
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
| User | Count |
|---|---|
| 23 | |
| 22 | |
| 14 | |
| 14 | |
| 13 |
| User | Count |
|---|---|
| 47 | |
| 39 | |
| 24 | |
| 20 | |
| 20 |