Forum Discussion
Dynamic CY/LY data points on Graph
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 🙂
2 Replies
- Greg_DecklerCommunity Champion
- FBergamaschiSuper User
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