Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
Solved! Go to 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! 🙂
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! 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |