Forum Discussion
undefined
Hi, I am currently trying prepare a graph for it to compare headcounts in 2022 and 2023. I have an area chart that shows the head count goal, current position filled, and critical. The headcount goal...
Hi benz-fsproduce,
You can create separate measures for the years like:
Current Positions 2022 = CALCULATE(SUM('Table'[Value]),FILTER('Table','Table'[Year=]=2022))
But I'm curious. You will still have the month year in the X-Axis. Are you planning to show the numbers only for months on the axis with lines for different years? Because otherwise it seems like a hassle when you have data for several years.
Did I answer your question? Mark this post as a solution if I did!
Check out this blog of mine: How to Export Telemetry Data from Azure IoT Central into Power BI
I want just the month on the x-axis, but when I do this happens.
