Forum Discussion
Market Study Brand Funnel
- 2 years ago
Based on the provided description, it is difficult to understand what you are trying to achieve and what the goal is.
In order to make it easier to advise on which visualization to choose, I would appreciate the following clarifications:
- What exactly are you measuring at each stage of the funnel? (Quantity of something, time, something else?)
- Is the comparison between brands or are you looking at each brand separately?
- Who is the audience for this report?
I would also recommend attaching a sample of the data or a link to the PBIX file.
- 2 years ago
Hi again Batten_Company
You should bring this table to the form :Brand Funnel stage QTY a Awareness 10
a Consideration 8 a Purchase 5 b .... ... b .... b ... ..... Create a simple ranking chart like mine on the attached picture (+ filter/slicer for selecting a brand)
In your case, the KPIs will be the stages of your funnel.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly - 2 years ago
Attach your table example not as a screenshot and I will try to help.
Or try to use the linked guides :
https://www.youtube.com/watch?v=ESap6ptV8fIhttps://www.youtube.com/watch?v=aEezNicgHkE
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi again Batten_Company
You should bring this table to the form :
| Brand | Funnel stage | QTY |
| a | Awareness | 10 |
| a | Consideration | 8 |
| a | Purchase | 5 |
| b | .... | ... |
| b | .... | |
| b | ... | |
| ..... |
Create a simple ranking chart like mine on the attached picture (+ filter/slicer for selecting a brand)
In your case, the KPIs will be the stages of your funnel.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi Ritaf1983
yes, that looks like what we are trying to achieve! How would we be able to transform our table into one like yours?
- Ritaf19832 years ago
Super User
Attach your table example not as a screenshot and I will try to help.
Or try to use the linked guides :
https://www.youtube.com/watch?v=ESap6ptV8fIhttps://www.youtube.com/watch?v=aEezNicgHkE
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly