Using dynamic values

[JSmart913]

I have 2 visuals - one displaying the current month data and one displaying last year same month.  I would like a way to show whether we are up or down this month from last year and since i cannot do conditional formatting based on a value in the other visual - can  i do a dynamic value to show this?  And if so how do i do it?.  It is based of of calculations that I added to the visuals on the web app

[lbendlin]

Consider combining them into a single visual.

[JSmart913]

So I tried this by pulling in the date field but when i use the same period last year the data doesn't pull in - I get the following error:

and I cannot pull in the date field otherwish it messes up the visual.  Thoughts?

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[JSmart913]

So this is essentially what i am trying to do

[JSmart913]

Company Name	Count of CSID for current April	Count of CSID for Last April
ABD	200	1225
FHN	150	125