Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ...
I got it after so much time spending on hit and trail...
valueloop solved me problem
but funnel chart allow only one measure i guess...
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...
tree map will allow only 1 measure .......
I got it after so much time spending on hit and trail...
valueloop solved me problem