Help to create a dashboard

Question

Hi everyone, I am a noob in Power BI. Used excel so far. I am trying to create a sales dashboard, where I need to calculate some complex data (Atleast for me). Can anyone help with below? If needed I can share sample data.

1. How to calculate contribution in BI itself from a set of data

2. For sales data how to calculate growth, where I would like to see below

a. Current Year Sales/Prior Year Sales

b. Current Year Sales for a particular Product/Prior Year Sales for a particular Product from a large set of data

3. Preparation of Scatter Chart with 3 type of calculated data from big set of data

a. Sales, Growth and Contribution - All of this have to be calculated

Also please share tutorial link to create relation between table and use in dashboard. If I am not wrong this option is similar to same feature of PowerPivot

greg_deckler · Answer

Going to need sample data. You could also download the dashboard in an hour and dashboard in a day material and this will walk you through working with sales data to build reports and dashboards.

rajibmahmud · Answer

Attaching 2 set of sample data.&nbsp;http://www.fileconvoy.com/dfl.php?id=g30fb6f71eacc7da9999963241a1d1b182f0a737bc&nbsp;&nbsp;Also, where can I find the material you reffered?&nbsp;

rajibmahmud · Answer

Bump!

v-huizhn-msft · Answer

Hi&nbsp;rajibmahmud,In Power BI desktop, click the Get Data on home page-&gt;Excel, import your resource table into Power BI desktop. You can create measure&nbsp;and calculated columns like Power Pivot. And the DAX in Power Pivot is also correct in BI.1. How to calculate contribution in BI itself from a set of dataWhat's your of this problem? How to calculate contribution based on your sample data?2. You can create a Calendar Tbale, and create a relationship between sales Table and Calendar Table.&nbsp;a.&nbsp;Current Year Sales/Prior Year SalesTotal Sales = SUM(Sales[SALE]) Total Sales YTD = TOTALYTD(Sales[Total Sales],'Sales'[DATE]) Total Sales YTD Last Year = CALCULATE([Total Sales YTD],SAMEPERIODLASTYEAR('date'[date])) b. You can add a filter like FILTER(Sales,Sales[Product]="UK"). Total Sales = CALCULATE(SUM(Sales[SALE]),FILTER(Sales,Sales[Product]="UK"))Total Sales YTD = TOTALYTD(Sales[Total Sales],'Sales'[DATE])Total Sales YTD Last Year = CALCULATE([Total Sales YTD],SAMEPERIODLASTYEAR('date'[date]))3. Create a Scatter Chart, select the corresponding measure or calculated columns as fields. Because of your data is part, I am unable to reproduce your scenario.&nbsp;For creating relationship between tables, please review this article.Best Regards,Angelia

rajibmahmud · Answer

Hi&nbsp;v-huizhn-msft&nbsp;Thanks.&nbsp;&nbsp;Regarding Growth calculation,&nbsp;Suppose I would like to see growth from below table. Adding custom column will help? As i would like to see growth of Product A or B seperately or Total Growth based on selection criteria. Also, there would be scenario where I would like to see Sales and Proft growth from same data set.&nbsp;YearMeasureProductValue2016SalesA102016SalesA202017SalesB302017SalesB402016ProfitA52016ProfitA102017ProfitB152017ProfitB20&nbsp;&nbsp;Also, do I hae to add calculated column for each measure, as I will be needing many such calculated number. What I am wondering is, will it be possble to create another table in BI itself where all the calculation will be done.&nbsp;Regarding :&nbsp;1. How to calculate contribution in BI itself from a set of data&nbsp;The issue is the same. I am trying to calculate&nbsp;- Discount % on Sales for a product or multiple product or Product Region etc combination

Forum Discussion

Help to create a dashboard

6 Replies

Related content

Creating a Dashboard for operations

How to create a beautiful Power BI Dashboard/Report?

Create an Organisation chart Dashboard on PowerBI with interactivity

creating Data Quality Dashboard

Creating relationships