Question. How does the data get grouped in descending order? Is it just grouped by quantity of individuals per category? Say we have 3 categories 1, 2 and 3. How does it know the order of “cascading” individuals per category?
@PowerBIBro
6 күн бұрын
Thanks for your support and for this question! Offhand, if I am understanding your question correctly, I believe the answer is that it is grouped by quantity of individuals per category. By default, in then sorts these buckets into ascending order, you can click the [...] in the upper right to change to sort in descending order. Hope this helps, please let me know if this answers your question!
@victoraguirre7486
6 күн бұрын
It does yes! I was wondering about if there was a reason to show a certain order, rather than having them show up grouped by quantity
@PowerBIBro
6 күн бұрын
Gotcha, yes that can certainly be a reason! It's possible to sort by category instead of quantity, so if there is a logical order you'd like to sort the bars in, you can do that as well instead of the quantity. Simply choose to sort by category and you're all set!
@bibybsa7921
8 ай бұрын
Great video (new subscriber, and github follower :)) wonder if 487 is the total of opportunities, why isn't 487 the 100%? Never worked with Funnel Charts, so this video is inspiring me. Many thanks, keep up the hardwork!
@PowerBIBro
8 ай бұрын
Thank you and great question! Every opportunity goes through stages. So if there was just 1 opp in our data, and it made it to the “finalize” stage, there would be a ‘1’ value across all 5 funnel stages for this 1 opportunity. Hope this helps and thank you for your support!
@bibybsa7921
8 ай бұрын
@@PowerBIBro Cool. IMHO, maybe it's a costume in my industry, I'd prefer to see the total as first stage, I managed to do it by adding a calculated table with this code: SalesStageSummary = UNION ( SUMMARIZE ( Opportunties, Opportunties[Sales Stage], "Quantity", COUNTA ( Opportunties[Opportunity ID] ) ), ROW ( "Sales Stage", "Total", "Quantity", CALCULATE ( COUNTA ( Opportunties[Opportunity ID] ), ALL ( Opportunties ) ) ) ) Do you know, if I could have done this within the [# Opportunities] measure? I think I cannot use a table as a variable in a measure and call it in the funnel chart, since it needs the category too. btw, just realized the table is called "Opportunties" :P tiny typo. Many thanks for answering!
@adrianojr9974
2 ай бұрын
@@PowerBIBro I don't think this is very usefull, once working with big data, doesn't make sense, performatic speaking to multiply your data across the stages, am i getting it right?
@adrianojr9974
2 ай бұрын
My question here is, doesn't the funnel chart works for also filtering data? Unlike the other charts? I understand that, we generally use measures in funnel charts and the result of interacting (clicking) in a measure does not affect the whole context, but even if we use numeric calculated columns as the steps of the funnel and interact with'em, they don't change anything in the filtered context. I guess it's because the sum of a column (represented by the funnel step) also considerates blank values. So, this is a problem i see with the power bi funnel charts. Any ideas?
@PowerBIBro
2 ай бұрын
Thanks for this question, glad you reached out! The funnel chart definitely works like other charts...eg. click a section of the funnel chart and it will act as a filter. Make sure these two items below are setup, you may just be experiencing a side-effect of another issue. If you open the file in the repo which I use for this demo then make these updates it should function as you expect, let me know if this helps! 1. edit the model relationship, change the link between [Stage Stage] to have 'BOTH' as the setting for Cross-filter direction, it's currently 'Single. 2. open up the options, go to report settings, edit default interactions to be cross filtering instead of cross highlighting. Hopefully this demo's the intended functionality!
@adrianojr9974
2 ай бұрын
@@PowerBIBro Thx for aswering, Just saw your pbix file, but the problem remains: Considerating Lead if the first stage of your funnel chart well, you don't have 268 Lead (passed by) the lead stage right? Here we see a diference in the funnel chart logics. If you have a universe of 478 register and your first step of the pipeline is "lead", my funnel chart will display 478 leads (passed by) at the first step, and yours, 268 leads (stopped at). So if you would follow this "pipeline" logic, what would you recommend to use the funnel chart to filter the other visuals?
@hafizasim4245
14 күн бұрын
where is the total of all
@PowerBIBro
12 күн бұрын
Excellent question and thank you for asking it! Unfortunately, to my knowledge by default there is not an option to add a total value, however it is possible via a work around! You can create a KPI card which calcs the total and overlay it on the funnel chart. Here's an article describing this approach. Hope this helps and thanks for your question! community.fabric.microsoft.com/t5/Power-Query/Add-Total-Row-to-Funnel-Chart/m-p/857002#M28810
@hafizasim4245
12 күн бұрын
A better solution might be to union two tables which add a total I read this solution over bi community and achieved the same
Пікірлер: 18