Offer: Nine needs material adapted from various workshops by Jose Lena Stevens, Pivotal Resources and JP Van Hulle, Michael Education Foundation.
Analyzing research that have Electricity BI has been interesting to me. Having ever before-expanding research happens so much more risk, and therefore so much more defense will become necessary. In this article, I will expose exactly what row-top defense inside Stamina BI are as well as how will it work. I’ll along with show in detail how exactly to implement a comparable for the Fuel BI Desktop computer. Later on, we are going to along with mention ideas on how to apply which line-peak safeguards within the Energy BI service also. To know about line-top cover during the SQL Machine, please take a look at my personal earlier in the day blog post, where You will find explained just how to use an equivalent.
Importing Data into Strength BI
The first step inside the proving one Power BI feature will be to load brand new dataset for the Power BI ecosystem and construct the latest required artwork. Because of it post, I will utilize the famous AdventureWorksDW databases, since the provided by Microsoft. You might down load that it database and also have they mounted on your Desktop computer.
Find several tables regarding AdventureWorksDW databases. I have selected a few tables on databases, which can be as follows.
Finally, would an example overview of and that you want to pertain new row-peak protection when you look at the Energy BI. For it example, I’m going to place brand new row-peak protection toward SalesTerritoryGroup column. Clearly, the SalesTerritoryGroup line is further split into SalesTerritoryRegion. When we designate spots to help you a certain area category, merely study relevant for this class could well be noticeable when you find yourself most other details was undetectable from the display screen.
To use line-peak safety for the Stamina BI, navigate to the Acting loss at the top, and select Create jobs.
When you click on Create, you should have a summary of dining tables throughout the research design away from which you yourself can come across a filter to put on the fresh new row-peak coverage.
Alter the “value” throughout the DAX phrase which have a real worth on SalesTerritoryGroup. Let’s are the worthy of due to the fact https://datingranking.net/cs/hitch-recenze/ “Europe” and you will in a way that this role often filter out investigation just for those individuals facts to possess European countries because the area category.
Eventually, let’s manage a task to have an employer who wants to display sales round the European countries and you can North america. We need to render use of these two regions towards manager. You can use the next phrase so you’re able to designate more than one really worth having a job.
Now that i’ve developed the positions let us just do it to check out the latest execution from inside the real. There’s a choice when you look at the Stamina BI, in which we could understand the profile from the context of your opportunities that individuals only written. This helps us shot whether your DAX filter expressions try working as expected, just in case this new row-top defense into the Stamina BI is followed precisely.
Let us make an effort to see how the newest accounts browse if we pick a different sort of role. Find European countries since the role and you will proceed to come.
Possible note that the new statement produces the fresh new visualization, however, simply for the particular part that is selected. You may see on the remaining-hand finest that it’s said once the “Today enjoying declaration because Europe”. Find the places just for European countries is actually filtered and range graph today suggests only 1 line, which is having Europe just.
Given that I’m going to filter toward region category, I will build this new DimSalesTerritory and choose Create Filter out following see new line SalesTerritoryGroup
Clearly now, all the regions belonging so you’re able to The united states as being demonstrated and an individual line for the very same regarding line graph.