Forum Discussion
Funnel chart without category
Hi everyone,
I have a Power Bi report that uses funnel charts throughout the report. The data is large ~700 rows of data.
Everything is fine with the exception of one funnel chart that does not use a data field in the Category. It has sum data in the Values. Because of this the visual will not show as a true funnel (largest to smallest or vice versa). I can't use any of the table data fields as category and the report must use funnel only. My question, is there a way to have a separate table or a column that would somehow link to each instance the value field example Business Leader is found? Here is snip sample of the data.
| Date | Regional | Business Leaders | Local Leaders | State Electeds | Local Electeds | Non-Profit/Community |
| 2/2/2023 | East | 4 | 19 | 2 | 5 | 8 |
| 2/4/2023 | Central | 22 | 17 | 3 | 7 | 10 |
| 3/2/2023 | West | 3 | 32 | 4 | 6 | 8 |
| 3/4/2023 | Northwest | 5 | 10 | 4 | 10 | 9 |
| 3/10/2023 | East | 1 | 9 | 8 | 7 | 6 |
this is what it looks like
Anonymous , You can create measures and use that in the funnel, You can decide the order of measure.
Or create a calculation group on measures and us that
Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0
2 Replies
Anonymous , You can create measures and use that in the funnel, You can decide the order of measure.
Or create a calculation group on measures and us that
Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0
amitchandak - thank you for responding. I have looked at the video and found it very helpful. For this issue that I was having, I resolved it by using Unpivot on the columns in the power query transformation. It worked perfect!