Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
Anonymous
Not applicable

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.

DateRegionalBusiness LeadersLocal LeadersState ElectedsLocal ElectedsNon-Profit/Community
2/2/2023East419258
2/4/2023Central22173710
3/2/2023West332468
3/4/2023Northwest5104109
3/10/2023East19876

this is what it looks like

 

jamaicawi_0-1680292237142.png

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@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

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

@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
Super User
Super User

@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

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.