Forum Discussion

Carina's avatar
Carina
New Member
9 years ago
Solved

Show Funnel Visualization Data in a seperate Table

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!

Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    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

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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's avatar
      Carina
      New Member
      9 years ago

      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's avatar
        Anonymous
        Not applicable
        9 years ago

        Carina,

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

        Regards,