Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Funnel chart upside down

Hello, is there a way to plot funnel chart upside down? Meaning lowest number on top, and highest on the bottom? Or is there anything similar to the pyramid? Couldn't find pyramid in the custom visua...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Anonymous 

     

    This is how funnel chart may look after sorting it :-)

KateSPhoenix's avatar
KateSPhoenix
Frequent Visitor
3 years ago

I would love a solution to this that actually still shows the correct conversion....as in 100% would be at the bottom and would go incrementally smaller as you go up the pyramid. Seems like its not a solution otherwise. The link to the other "solution" doesn't help either. Does anyone know of a solution that just simply allows you to stack it in pyramid with the correct conversion percentages? I don't want them to simply be off of the chart.

MFelix's avatar
MFelix
Super User
3 years ago

Hi KateSPhoenix ,

 

This visualization is the Funnel show it's calculates from top to bottom considering always the 100% at the top.

 

I see two option for this to check for custom visualizaitons on the store, the other is using dynamic format for measures:

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-dynamic-format-strings

 

Using this you can create a measure that is the SUM of your value and the add the followig format string:

VAR TotalFormat =
    FORMAT ( [Total], "#,##0" )
VAR PercentageFormat =
    FORMAT (
        DIVIDE (
            [Total],
            MAXX (
                DISTINCT ( ALL ( 'Table'[Value] ) ),
                CALCULATE ( [Total], ALL ( 'Table'[Category] ) )
            )
        ),
        "#%"
    )
RETURN
    """" & TotalFormat & " (" & PercentageFormat & ")"

Now turn off the converison rate on the funnel and final result is below: