Funnel chart upside down

[Anonymous]

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 visualizations. Thank you.

[MFelix]

Hi @Anonymous ,

You just need to click on the 3 dots on the up right corner of the visual and sort ascending by the values.

Regards,

MFelix

[Anonymous]

Hi @Anonymous ,

You can refer this https://community.powerbi.com/t5/Desktop/Funnel-Chart-Sorting/td-p/511773.

I hope this helps you:-)

If yes please accept this as solution so that it can help others too

[Anonymous · Accepted solution]

Hi @Anonymous 

This is how funnel chart may look after sorting it 🙂

[KateSPhoenix]

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]

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: