Don't miss your chance to take the Fabric Data Engineer (DP-600) exam for FREE! Find out how by attending the DP-600 session on April 23rd (pacific time), live or on-demand.
Learn moreNext up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now
Hi,
I would like to display a table that has the similar patterns to waterfall chart. (essentially works in the same way)
Does anyone know if there is such a visualization? I tried the tables but it seems like the only possible way is to do measures if I want it to display values like a waterfall chart.
So essentially the total is a measure a have and usually in a waterfall chart, they will automatically breakdown into the dates such as in this way. But is there a table that can do this?
| Jan | Feb | Mar | Total | |
| Apple | 1 | 2 | 3 | 6 |
| Grape | 2 | 4 | 2 | 8 |
| Orange | 5 | 0 | 0 | 5 |
Hi, @kitala11
Based on your description, i created data to reproduce your scenario. The pbix file is attached in the end.
Table:
You may create a matrix visual as below.
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@kitala11 , Are you looking for Hybrid table. Month on columns and total as onr more value at end ?
if you are looking for a Hybrid display with Matrix Column and measure
https://community.powerbi.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1...
https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/...
vote for Hybrid Table
https://ideas.powerbi.com/ideas/idea/?ideaid=9bc32b23-1eb1-4e74-8b34-349887b37ebc
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Experience the highlights from FabCon & SQLCon, available live and on-demand starting April 14th.
| User | Count |
|---|---|
| 48 | |
| 40 | |
| 37 | |
| 20 | |
| 16 |
| User | Count |
|---|---|
| 70 | |
| 67 | |
| 32 | |
| 27 | |
| 25 |