You have been requested submit your pbix file

Description: Modelling in Power BI About Assignment  

You have been hired as a Power BI Developer for X Company. Your manager is struggling to get the data in the right format. The manager is asking to look into the data:  

Create a Table visual on the report page: Your manager asks you to create a table using order quantity from the order table and sales from the sales tables. You have also been asked to check on the following conditions: Whether the issue of many-to-many relationships arises with the created table? Apply the color gradient to values in the tables to identify the highest sales and lowest sales. Kindly use red color for minimum sales and green color for maximum sales.   Create a Scatter Chart on the report page: You have been asked by the manager to create a scatter plot using sales and quantity information and represent it, which helps identify the highest and lowest sales using color.   Play axis on the report page: Your manager wants you to apply the play axis on a date and see how the scatter plot changes from time to time. You also need to ensure that the play axis does not apply to the table you created.        

After completing your task, you have been requested to submit your .pbix file.      

DAX Expressions Part1    

Your manager is struggling to get further insights which requires some Measures and Calculated Columns. Requirements are divided into Part1 and Part2. In continuation with the previous assessment, following are the new requirements of Part1 given by manager:   GST Column: A calculated column called GST with an 18% tax slab on sales amount needs to be created on sales amount. Date difference column: A date difference column needs to be present that shows the delay between the order date and the ship date. Sales Buckets: You need to create sales buckets with the condition as follows: Sales lesser than 1000 Sales between 1000 to 5000 Sales between 5000 to 10000 Sales between 10000-15000 Sales between 15000 to 20000 Sales above 20000 Total Sales: A total sales measure with a filter segment = corporate is needed. multi-row card: You need to create a multi-row card with min sales, max sales, average sales, and mode.   After completing your task. You have been requested to submit your .pbix file.