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

[jithu]

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]

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

[jithu]

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]

try with treemap chart

[jithu]

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

[jithu · Accepted solution]

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

valueloop solved me problem