Because they are very simple to use , Drag in the field to display the data , Looks like Excel The forms are no different , First contact PowerBI People can use it easily , But they are far more functional than they seem .
The following is a comprehensive introduction from connotation to appearance PowerBI The table in .
Let's take a look at the more complicated “ matrix ” object , Take the sales data of this electronic product as an example ,
choice “ matrix ”, Put... In the date table [ date ] Drag into 【 That's ok 】, The system will automatically layer the date field , hold [ The product name ] Drag into 【 Column 】,[ Sales amount ] Drag into 【 value 】, A form comes out ,
From a static point of view , This is a simple form , but PowerBI Of course, it doesn't look like this , Its tables are also dynamic 、 Interconvertible .
Drilling and interacting
Because when you add a date , Dates have been automatically layered , So you can drill in various date granularity directly on the line ,
This is drilling through the row header , If there are hierarchical dimensions on the column header as well , Drilling operation can also be carried out .
Put field [ The product name ] Drag into 【 Column 】 in , At this time, there is a drop-down box in the upper left corner , You can choose 【 That's ok 】/【 Column 】 Drilling ,
Use the drill button above to operate , Drill through is applied to all categories , If you want to drill through only one of these categories , You can also use the right-click operation , Drilling flexibility is greatly enhanced ,
About drilling , You can also refer to :PowerBI skill ： Drilling of charts
In essence, tables are also visual objects , So it's no different from other charts , Not only can you drill into , Of course, you can also interact with other charts , It can also be screened 、 Or cross select other visualization objects , I'm not going to show you one by one .
Format is set
PowerBI The default table is the style above , You can change the style in the formatting ,
I can't help but make complaints about it , One of these system styles is worse than the other , The default one is the most pleasing , If not satisfied , We can also use Fonts 、 Color 、 Various custom settings such as borders , For example, I personally like to set this simple ,
The most eye-catching format setting is conditional format , You can set various color scales .
Background color scale
Turn on the background color scale , The default effect is also striking , Let's order 【 Advanced controls 】 Set it up ,
There are several settings to choose from , We set the color divergence directly according to the maximum value and minimum value , The background color scale effect is as follows ：
The larger the amount , The darker the background color .
Font color scale
Set as above , I won't repeat , Look directly at the effect ,
The most commonly used one should be this data bar , The effect is as follows ,
The data bar can also set different colors for positive and negative values , You can set it up yourself .
Finally, except for “ matrix ” The other one “ surface ”, Just drag the corresponding field into the value , It's a simple form , You can also format data bars like a matrix , But you can't use drilling and other functions , There was nothing to introduce , Until I saw this function ： Automatically find clusters .
Automatically find clusters
This function can automatically transfer the information in the form , Automatically divide the data into different sets according to the internal relationship of the data , And automatically create a new field .
But use the auto find cluster feature , You need only one dimension in the table , And no more than 15 A measure of , If not , It will prompt ：
Let's demonstrate this function ：
Suppose there are scores of different brands of thermos cups , Create two new measures ： The average of product score and service attitude score , We add the brand name and these two metrics to the table ,
Click on the three points in the upper right corner of the table , This menu will appear , choice 【 Automatically find clusters 】,
Then a field is automatically created and automatically displayed in the table ,
You can't see in the table what the new cluster is for , I don't know how the system is divided into different clusters , But we can put that data into a scatter plot , Let's see what rules they have ,
It is obvious from the scatter diagram that , Different clusters are clustered in different areas according to different colors , The brands of these thermos cups are divided into different collection levels according to product rating and service attitude , That's the power of auto discovery clustering .
After the table is automatically divided into clusters , This new field , It can be used in other visual objects , Like the scatter plot above , Can let us find the law between the data faster .
The above functions , Have you ever used them ？