Funnel chart without category

[jamaicawi]

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

[jamaicawi]

@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! 

[amitchandak · Accepted solution]

@jamaicawi , 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