topic Re: Multiple different parameters into Single graph in Developer

Multiple different parameters into Single graph

JackR07 — Mon, 26 Nov 2018 17:28:10 GMT

Hi,

I am trying to figure out a way to input three different parameters into 1 single linear graph for the output. Currently, I have three separate graphs that generate 1 output, but I want 1 single linear graph with all three parameters imported and combined to produce the output.

Any help would be appreciated.

Re: Multiple different parameters into Single graph

v-chuncz-msft — Tue, 27 Nov 2018 08:27:29 GMT

@JackR07,

The requirement is not very clear. You can implement a measure using parameters by using SELECTEDVALUE.

Re: Multiple different parameters into Single graph

JackR07 — Wed, 28 Nov 2018 20:57:12 GMT

Yes - However in PowerBI I have 3 graphs 3 Parameters - I want to use 1 graph for all 3 parameters so that 1 graph is producing the output of 3 parameters instead of having 3 graphs with each parameter assigned to each one

Re: Multiple different parameters into Single graph

shishir999 — Tue, 04 Dec 2018 06:24:01 GMT

Try this:

1. Create a table using : GENERATESERIES(1, 3, 1).

2. Assign Parameter Title to each number: Param_Type = SWITCH(Type[TypeNo], 1, "Price", 2, "Weight", 3, "Volume").

3. Create one Measure:

Param= IF(SELECTEDVALUE(Type[Param_Type])="Price", [Price],

IF(SELECTEDVALUE(Type[Param_Type]) = "Weight", [Weight],

IF(SELECTEDVALUE(Type[Param_Type]) = "Volume", [Volume] , [Price] ) )

4. Use this PARAM as the value into your graph.

Shishir Goel

**Please Mark it as Solution, if works for you**