Forum Discussion
Funnel Chart in Power BI
Hey Anonymous
I would create a second table with your percentage ranges (10%-20%, etc.) and then add a calculated column with a Calculate(Count(Filter())) measure exemplified in the thread below:
https://community.powerbi.com/t5/Desktop/Countif-with-multiple-criteria/td-p/540996
Or you can simply use a COUNTX with an embedded AND statement.
COUNTX: https://docs.microsoft.com/en-us/dax/countx-function-dax
AND: https://docs.microsoft.com/en-us/dax/and-function-dax
Then you can use the second table as the basis for your Funnel Chart.
If this helps please kudo.
If this solves your problem please accept it as a solution.
Hey Anonymous
I would create a second table with your percentage ranges (10%-20%, etc.) and then add a calculated column with a Calculate(Count(Filter())) measure exemplified in the thread below:
https://community.powerbi.com/t5/Desktop/Countif-with-multiple-criteria/td-p/540996
Or you can simply use a COUNTX with an embedded AND statement.
COUNTX: https://docs.microsoft.com/en-us/dax/countx-function-dax
AND: https://docs.microsoft.com/en-us/dax/and-function-dax
Then you can use the second table as the basis for your Funnel Chart.
If this helps please kudo.
If this solves your problem please accept it as a solution.
Could you please share a template if possible ?
Hey Anonymous
I didn't log in at all over the weekend, but I see you accepted the solution. Did you figure it out or did you still need a template?
Hi Tad,
I got the solution. Thank you.