Show Funnel Visualization Data in a seperate Table

[Carina]

Hi,

I created a funnel for my report that works with different filters and entry points. 

My challenge now is that I do not only want to show the visualization but also the underlying data / percentage of first and percentage of before in a seperate table.

When I choose "show data" the table only shows me the absolute (underlying) data and no calculations which are available in the chart itself when pulling over the bars.

Is there an easy and quick way to get this table? Otherwise I need to make the calculations seperately.

Thanks a lot in advance!

[Anonymous · Accepted solution]

@Carina,

You would need to calculate percentage of first and percentage of before using DAX, then create table visual to show these values. There is an example for your reference.

Percent of First = Table3[Amount]/CALCULATE(SUM(Table3[Amount]),FILTER(Table3,Table3[Index]=1))
Previous = CALCULATE(SUM(Table3[Amount]),FILTER(Table3,Table3[Index]=EARLIER(Table3[Index])-1))
Percent of Previous = IF(ISBLANK(Table3[Previous]),0, Table3[Amount]/Table3[Previous])



Regards,
Lydia

[Carina]

@Anonymous

Thank you very much for your help!

I managed to calculate the percentage of the first, but the formular for the previous does not work for me. 

For some reason the EARLIER Formular does not work. The error message I get is "EARLIER/EARLIEST verweist auf einen früheren Zeilenkontext, der nicht vorhanden ist."  - the earlier formular refers to a row context which is not available.

Do you have any idea what the reason for this could be?

Best regards,

Carina 

[Anonymous]

@Carina,

Right click your table, select "New column", then apply the DAX I provided.

Regards,