Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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
Hi @Anonymous
This is how funnel chart may look after sorting it 🙂
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.
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:
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |