You will find lots away from stuff on the complex information out-of Power BI acting like complex DAX, and you may perspective transition. not, according to my personal experience in our very own customers, I ran across discover a giant gap inside very first posts. Hence, this information is attending coverage the fundamental essentials of your own matchmaking. Information like: What is a relationship? So why do you need it? And you can what is happening rationally about the scene out of a romance? To learn more about Fuel BI, see Stamina BI guide regarding Newbie so you’re able to Rock Celebrity.
What’s the Dating inside the Energy BI?
Why don’t we glance at the concept of a love due to an example; Let’s say you may have just one desk to have Shop, and you should get to know that when you look at the Stamina BI. The Shop table ends up so it:
On the Electricity BI declaration, if you wish to build an effective visualization which is the matter regarding locations inside the Condition, it might be such as this:
Clearly, the official normally filter brand new table to show new count off suggestions each condition. If i need certainly to photo the fresh new selection, it would be in this way:
Imagine if more than one desk?
Today let us check what goes on when we have more than simply that table; What if there can be a-sale desk along with included in the answer. Transformation desk possess some guidance, such just how many of each guide term, where time, on exactly what store comes. Is good screenshot of one’s data on the Transformation table;
In order to discover dating, I actually do suggest one power down the vehicle-choose relationships (I really don’t suggest usually! Just for the goal of it understanding). Acquiring the automobile-position relationships finishes you against studying what’s going on about the fresh new world. When you need to shut down this feature, you will want to very first check out options regarding Power BI Pc;
Whenever we load product sales dining table including in identical service, today we will see a couple dining tables. With no dating (because auto-choose matchmaking was turned-off) just like the lower than;
Today, if we need to filter out to check out what’s the total Qty out-of guide headings available in each shop, we are able to do this using an artwork instance lower than;
This would be very similar to the past visualization to your Shop desk. Brand new selection goes all-in-one dining table, although not, this time around the fresh new desk are Sales;
Clearly regarding the more than visualization, the entire out-of qty per condition was 493! And the full qty on Sales dining table is additionally 493! Without a doubt, this time selection failed to occurs precisely. Once the Conversion only is aware of the stor_id, maybe not the official:
When we need certainly to filter so it table of the store, the sole occupation providing you with you for example ability was stor_id and this cannot know any single thing in regards to the county.
While doing so, a shop dining table has the state job, but knows little concerning the Marketing and you may Qty! Yet not, there is an excellent stor_id field contained in this table too. The novel id of one’s store per for every single line (store);
Within this example, we want one another tables, while they each other contain areas that individuals need inside our visualization: County career from Shop desk, and you can Qty field about Transformation table. This new stor_id community is the industry that can assist you in looking up you to definitely value in the other table. Why don’t we observe that compliment of an illustration:
The sales desk in addition front side, write to us how much cash transformation we’d from the shop 7066 (which is Barnum’s store);
These dining tables are going to be linked to each other, playing with stor_id. Or can you imagine they put another way; both of these dining tables is going recommandé de lire to be Connected with one another utilizing the stor_id job.