Learn Python
Learn Data Structure & Algorithm
Learn Numpy
Learn Pandas
Learn Matplotlib
Learn Seaborn
Learn Statistics
Learn Math
Learn MATLAB
Learn Machine learning
Learn Github
Learn OpenCV
Learn Deep Learning
Learn MySQL
Learn MongoDB
Learn Web scraping
Learn Excel
Power BI Introduction
Power BI Home tab
Power BI Insert tab
Power BI View tab
Power BI Graph_chart
Power query interface
Power query text functions
Power query number functions
Power query date functions
Some important topics
M functions
Grouping
Learn Tableau
Learn Docker
Learn Hadoop
If you import any table then you can see that in the yellow marked area. To create a chart first select columns from the yellow marked area by clicking on the check box given beside the column name and then go to the green marked area and select a chart according to your need. In the chart, you can see the black marked and gray marked areas. To see the chart in the whole window click on the black marked area. If you go to the gray marked area then you will see a lot of options there. Here you can sort the chart in ascending and descending order. There is another option for sorting and that is sort by. By this option, you can decide that the sorting should be done according to which column. There is another option that is spotlight. This option highlight the graph. Remove the chart by clicking on the remove option present in the gray marked area. You can also delete a chart by clicking on the delete button(in keyboard) after selecting the chart by clicking on the charts. There is another option name shown as a table. If you click on this option then the chat will display like: on the top you will have the chart and on the bottom, you will see the selected columns( which you have selected to create the chart) as the table.
Blue marked area: This area is used to edit or modify or update and decorate a chart. To do this you have three options which are marked in orange,brown and purple color.
Orange marked area:
These options are used for the update or edit chart y-axis, x-axis, legend and tooltip columns. Here axis
means you will put a column for the x-axis of the chart. To put column just drag the column from the yellow
marked area and just drop here. For other like value, tooltip column putting system is same. Value means you
will put a column for the y-axis of the chart. To get tooltip and legend just drag and drop the columns
according to you need. You can put multiple columns in the value, axis and tooltip section.
For example, if you want to use a column as a legend then drag the column and drop it in the legend section.
For others like value, tooltip, and axis the process is the same. To remove a column you can see a cross sign
beside the column name, just click on that.
Purple marked area: Here you get options to decorate the charts. You can color the text, chart, axis values, background-color and many more things. First, select the chart and come to this option and decorate the chart according to your need. It's easy and simple.
Brown marked area:
In this area you can add the minimum line, maximum line, average line, median line, percentage line, etc in
the chart.
Suppose you want to add a minimum line for a chart.
To do this:
Step 1: Select the chart
Step 2: Come to this area
Step 3: Click on minimum line
Now click on the green marked area and write the minimum value.
If you want to add multiple minimum line then click on add line option present in the red marked area.After
clicking a new area will be display in the green marked area. There you can write the minimum value.
Look each chart is different. So the options for charts in the brown and purple marked area will be different.
Here different means, suppose for a bar chart you will get options for coloring the bars but for the line
chart, you will not get any options to color the bars. Here you will get options for coloring the lines. For
the bar chart, you will get an option for max, min, average, and percent point but for some other chart, you
will not get these options.
To align the charts just take the cursor on the chart and then move the chart.