Forum Discussion

lherbert501's avatar
lherbert501
Post Prodigy
1 year ago
Solved

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 🙂

 

 

Dummy Data types2.pbix

 

 

 

 

 

 

2 Replies