Profit dashboard

1. Profit dashboard

We are going to develop a dynamic dashboard in Power BI to show profitability ratios. First we insert a matrix table under Liquidity ratios. Then add in the Ratios from the new table "Profitability ratios". You will see all our profitability ratios added to the matrix. We then create a measure called Profit Margin. You will notice that the measures to create this measure are already given. We know that profit margin is net income divided by net sales, so we create a measure called “Actuals Selected Ratios Income Statement” to help display our profitability ratios in our matrix. First let's establish "Actuals Selected Ratios Income Statement" by using the VAR command and naming it selected ratio. Next we use the DAX function SELECTEDVALUE which returns the value of the column reference passed as first argument, in this case the selected table would be "Profitability Ratios" and the column would be Ratio. We then use return and the DAX Function SWITCH. SWITCH examines an expression against a list of values and returns one of multiple possible result expressions. We then set the equation to select the profit margin. To add the values of Profit Margin to our table, we add "Actuals Selected Ratio Income Statement" from our model measures to Values. Then we add ‘Year’ under columns from our date table. Now you can see that we have our current ratio DashBoard. We then turn off the row and column totals. We add a title, "Profitability Ratios", and update the formatting to match our income statement and balance sheet. Now it is your turn to complete the calculations of the other profitability ratios, asset turnover and return on assets.

2. Let's practice!

Create Your Free Account

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.