Forum Discussion
Custom visual Funnel plots
Hi experts,
Looking for your help here
We are trying to explore funnel plots for our reporting. We have created different DAX measures for population and occurance fields but when try to use it, it throws an error "Not enough Data Points for funnel plot"
We understand for funnel plots there should be atleast 10 data points, which we have in our data(32 cities).
here are the dax measures:
for Population - Total Sales = Sum(FactInternalSales[Sales])
for occurance - Supplier discount % (by city) =
var denom = CALCULATE(SUM(FactInternalSales'[Discount]),GROUPBY(Region,[City]))
return DIVIDE(num,denom)
3 Replies
Anonymous , I doubt a standard funnel plot need 10 points, One group and measure is needed.
Or which one you are using : https://appsource.microsoft.com/en-us/marketplace/apps?product=power-bi-visuals&search=funnel%20visual&page=1
Hi amitchandak
I am using Funnel plot by Microsoft corporation. For this visual, there should be at least 10 data points. We are grouping by city which should have more than 20 data points
Hi, Anonymous
It’s hard to figure out the problem without some sample data. Would you like to post some sample data(without sensitive data) and your expected result?
Thanks very much!
How to Get Your Question Answered Quickly
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
