Lines in visual in Power BI

[Analitika]

Hi,

I would like to ask how to make a visual where lines number be equal selected years number for example, I select 2021, 2022 then two lines appear in visual. Lines is described by measure. So how I could adapt my measure?

Here is a visual:

Measure looks like this:

[jcalheir · Accepted solution]

Hi,

First make sure you have a date table. If you dont know what this is, star by reading this article and do some reserach about this, so that you understand the concept.

https://kohera.be/power-bi/how-to-create-a-date-table-in-power-bi-in-2-simple-steps/

Then you can create something like this

Create a line chart and add to X-axis the Month, the facts to the Y-axis and add to the Legend the Year (This way you dont agregate you yearly values).

Then create a slicer for the year, and this way you can chose the years you want to display in the line chart

Kind regards,
José
Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂