Dynamic CY/LY data points on Graph

[lherbert501]

Hi,

I am having a problem with a graph layout and dynamic measure. I have attached the pbix with sample data below.

I currently have three field parameters which work okay to change the measure and X Axis, but I need to be able to, whilst the x axis is on the month option, to have current and previous year to the date on the x axis. I would then be able to continue to use the existing slicers at the top.

I'm unsure if it's possible as it would need to all be in the one measure I believe but still be dynamic, because it would need to give out two data points which it currently does not. A sample of the the required layout below also.

Does anybody have an idea how this could work within the structure I've attached on the same graph?

Thanks 🙂

Dummy Data types2.pbix

[FBergamaschi]

Here my file with solution

hope to have understood correctly your needs

https://drive.google.com/drive/folders/16fzM1Z2ux54pgkIc1AYNVJa0objTRu93?usp=sharing

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI

[Greg_Deckler · Accepted solution]

@lherbert501 See if this helps: https://community.fabric.microsoft.com/t5/Quick-Measures-Gallery/Better-Year-Over-Year-Change/m-p/28...