CODEWITHSUNDEEP
dynamicpowerbimeasuretimeserieschartgenerate
GDB007
GDB007

Reputation: 21

How can I generate a dynamic series in Power BI, for which the first value depends on a measure, and then plot on a visual?

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

Upvotes: 2

Views: 1281

Answers (1)

Alexis Olson
Alexis Olson

Reputation: 40244

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.

Upvotes: 1

Related Questions