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

Everything about import, use and modify graphs & charts in power bi

How to create a chart in power bi?

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.

How to modify or update and decorate a chart in power bi?

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.

How to edit chart in y-axis and x-axis, add legend and tooltip columns to a chart in power bi?




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.


How to decorate a chart in power bi?




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.


How to add the minimum line, maximum line, average line, median line, percentage line, etc to a chart in power bi?




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.

CodersAim is created for learning and training a self learner to become a professional from beginner. While using CodersAim, you agree to have read and accepted our terms of use, privacy policy, Contact Us

© Copyright All rights reserved www.CodersAim.com. Developed by CodersAim.