topic Re: Using dynamic values in Custom Visuals Development Discussion

Using dynamic values

JSmart913 — Thu, 17 Apr 2025 17:30:40 GMT

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

Re: Using dynamic values

lbendlin — Thu, 17 Apr 2025 20:39:30 GMT

Consider combining them into a single visual.

Re: Using dynamic values

JSmart913 — Fri, 18 Apr 2025 11:46:20 GMT

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?

Re: Using dynamic values

lbendlin — Fri, 18 Apr 2025 12:56:37 GMT

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-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Re: Using dynamic values

JSmart913 — Fri, 18 Apr 2025 14:02:15 GMT

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

Re: Using dynamic values

JSmart913 — Fri, 18 Apr 2025 14:02:38 GMT

So this is essentially what i am trying to do