topic Re: Funnel chart with only measures - working with 2 measures but not more than that in Visualization and Usability

Funnel chart with only measures - working with 2 measures but not more than that

jithu — Sat, 16 Nov 2024 21:21:13 GMT

I am trying to create a Funnel chart with multiple measures , no dimension (using synthetic dimension) .

Example : I have 3 measures

i.e. sum(stage1) , sum(stage2), count(distinct stage3) . I want to create a funnel to visual this and using some filters.

if I transpose the data using cross table then I am getting duplicates which is not correct . So I can't use with only 1 dimension and 1 measure.

So I have tried with the below solution but works only with 2 measures not more than that:

Dimension:

if (valuelist('stage1','stage3')

Measure:

if (valuelist('stage1','stage3') = 'Stage1',sum(Stage1),count(distinct Stage3))

This works perfectly .

If I add one more measure like the below one then there is an error in the measure expression

if (valuelist('stage1','stage2','stage3')

if (valuelist('stage1','stage2','stage3') = 'Stage1',sum(Stage1),sum(Stage2), count(distinct Stage3))

Is there any way to overcome this ...??? Any help would be appreciated . Thanks in advance.

I have tried the other funnel extension , but no funnel support only measures ...

Channa — Mon, 25 Feb 2019 12:15:06 GMT

but funnel chart allow only one measure i guess...

jithu — Tue, 26 Feb 2019 04:34:07 GMT

then we have to reverse pivot and do it .... in this case drill down 's will not give accurate numbers....

. Power BI has funnel chart with only measures .... similar way exploring other possibilities or work around to achieve the same here...

anyhelp would be appreciated...

Channa — Tue, 26 Feb 2019 06:39:46 GMT

try with treemap chart

jithu — Tue, 26 Feb 2019 09:25:44 GMT

tree map will allow only 1 measure .......

jithu — Tue, 26 Feb 2019 09:47:16 GMT

I got it after so much time spending on hit and trail...

valueloop solved me problem