On this publish I wish to clarify extra particulars about Energy BI Designer options. Within the earlier publish you learnt the best way to create some quite simple stories. Nevertheless, these stories have been only for testing basic options of the software. As an example we didn’t even play with quite simple options like renaming the dimension or reality tables and members to consumer pleasant names. On this article not solely do I clarify a number of the easy ones, but in addition I’ll undergo a number of the extra superior ones.
Once more, as per my earlier publish, I’m utilizing AdventureWorksDW2012 as a supply database. We imported “Web Gross sales” into the designer and we created some stories and one new web page and we saved the stories on disc. So we’ve all the necessities available. Let’s go…
Making names extra consumer pleasant:
Open the *.pbix report file in Energy BI Designer
Double click on on “DimCurrency” to rename it to “Forex”. We have to do the identical for all different objects
You are able to do the identical in “Question” part as properly. To take action, click on on “Question” then click on on the queries on the precise pane . Then on the “Question Settings” pane you’ll be able to rename the question (Energy Question makes use of the title “Question” for all imported objects which could possibly be tables, views and so forth.).
Hiding Unused Fields:
There are at all times some fields that shouldn’t be hidden from the top consumer sight. As an example, all ID fields ought to be hidden. You are able to do very simply from the “Report” part.
Managing relationships:
We’re going to take a step additional and take a look how we will handle the relationships between the queries. Click on on “Handle” from “Relationships” part on the ribbon.
As you’ll be able to see Energy BI Designer robotically detected some relationships. Trying on the relationships extra exactly, you’ll see that there are some lacking relationships. As an example, the connection between “Web Gross sales” and “Web Gross sales Cause” is missed. It’s because composite relationship will not be supported in Energy BI Designer. As the identical in reminiscence know-how as Tabular Fashions and PowerPivot is used it’s not a shock that composite keys will not be supported within the software. I’ve a publish relating to composite keys in tabular mannequin that you may want to take a look.
Now we wish to create a brand new relationship between “Web Gross sales” and “Web Gross sales Cause” queries. We’ll undergo the identical process as I defined on composite keys in tabular mannequin.
We wish to concatenate each key columns from each “Web Gross sales” and “Web Gross sales Cause” queries to make a brand new key column.
Click on “Add Customized Column” from “Add Column” tab from the ribbon
Identify the Column as “ID”
Concatenate “SalesOrderNumber” and “SalesOrderLineNumber” columns utilizing “&” operator then click on OK.
Go to “Report” part and click on “Handle” from “Relationships” part on the ribbon
Click on “New”
From the primary drop down listing choose “Web Gross sales”
Scroll to the top tight of the desk and choose “ID” column
From the second drop down listing choose “web Gross sales Cause”
The “ID” column ought to be highlighted. If it’s not, simply choose it.
Click on OK
Broaden File Column:
In the event you go to “Question” part and click on on “Web Gross sales Cause”, do not forget that we renamed it earlier than to make it extra consumer pleasant, you’ll see two extra columns added to the question that don’t exist within the authentic tables. The designer intelligently added the associated columns from different associated tables. Notice that we didn’t import “DimSalesReason” desk into the mannequin, however the designer detected the connection and added the associated column to the question fields. This is rather like what occurs in Energy Question whenever you’re going by the identical course of.
On this pattern, we don’t wish to import “DimSalesReason” desk into the mannequin. So we’re going to make use of an superior characteristic which known as “ExpandRecordColumn”. Utilizing this characteristic we’ll develop the “DimSalesReason” column so we’ll have some chosen columns of “DimSalesReason” side-by-side the “Web Gross sales Cause” columns.
To take action, simply merely click on on the develop button to the to the “DimSalesReason” column, tick “SalesReasonName” and “SalesReasonReasonType” the clicking OK.
As you’ll be able to the 2 chosen columns are added to the question.
Now rename the columns to consumer pleasant names. To take action, simply merely double click on on the column title and rename it.
Create a New Reviews Utilizing the New Relationship Created:
Navigate to web page 2 of the report and add the next stories to the web page. You need to have the ability to create the stories now 
:
Web Gross sales Quantity by Gross sales Cause Sort
Web Gross sales Quantity by Gross sales Cause
Now click on on promotion bar on the “Web Gross sales Quantity by Gross sales Cause Sort” visualisation and as you’ll see it impacts the opposite visualisasion as properly.
Within the subsequent article I’ll clarify the best way to make unbelievable dashboards utilizing the report we created to this point.
Take pleasure in.
