1

Looking to generate a series of dates and values on Power BI for which the first value and the increments depend on measures. (Dynamic series generation and then applying to visuals).

Tried do to this through a calculated column, however this was unsuccessful as the column is calculated before the filtering on the measure can occur - so it was providing me with undesired results.

I have also tried to use GENERATESERIES within a measure with UNION to combine the date and values series. However, I am then unable to plot this on a visual as I have multiple values for my measure.

Any help would be greatly appreciated. Cheers

GDB007

GDB007
  • 11
  • 1
  • 1
    Perhaps your trying to apply suboptimal solution to your problem. What is it that you're trying to achieve business wise? Can you display your desired end result and base data? – W.B. Feb 12 '21 at 10:29

1 Answers1

0

As long as you have a fixed X-axis, you can certainly define the Y-values dynamically using measures that are dynamic.

For example:

Chart

In this example, I just defined the [StartValue] measure as a constant 1 but it could be whatever you like. The [Increment] measure here just reads in the value of a small parameter table I created to show multiple values simultaneously by dropping that column in the Legend field of the visual, but this could also be whatever you like.

Alexis Olson
  • 38,724
  • 7
  • 42
  • 64