Forum Discussion
VAN WESTENDORP PRICING METER CHART
I'm currently trying to create this Van Westendorp Pricing Sensitivity chart in PBI, but I'm struggling with it. Does anyone have a solution? Here is my chart in Excel, but I want to be able to filter the chart based on the respondents' demographics, which is why I'm looking to do it in PBI.
Van West Analysis in Excel
- lbendlin
Super User
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523I've uploaded the Excel file that I want to replicate in PBI. The Record field is the Unique Key that I need to be able to filter.
- lbendlin
You can do this with a standard line chart and some x axis constant lines.
How do I create the table in the spreadsheet called 'Graph' from the table on the tab called 'Respondent Answer' in Power BI? If I can do that, then I get what you are saying about the line graph.
- lbendlin
What do you need that table for? You can create it by dividing the values by the total number of rows (600)
