How to create Pivot Tables in Power BI?

0 votes
Can anyone specify how to create Pivot tables in Power BI?
Feb 6 in Power BI by Roshni
• 600 points
325 views

1 answer to this question.

0 votes

Hey,

First of all, there is no "Pivot table" in Power BI, but there is a "Matrix Visualization", which is equivalent to a Pivot table in Power BI.

Let's take a look at how to create:

  • Select the Matrix Visual But NOT the Table visual.

*Matrix visual is equivalence to Pivot Tables.

  •  You’ll get similar options as you do in Excel i.e. Rows, Columns and Values​
answered Feb 6 by Gitika
• 29,170 points

Related Questions In Power BI

0 votes
1 answer

How to create final table based on Joins of two tables in power BI?

Hi Nithin, It is easy and simple. 1. Go ...READ MORE

answered Mar 1, 2019 in Power BI by Cherukuri
• 32,460 points
3,144 views
0 votes
1 answer

How to combine your data or tables in Power BI?

Power BI includes Query Editor which is ...READ MORE

answered Feb 27, 2019 in Power BI by Phalguni
• 1,010 points
365 views
0 votes
1 answer

How to combine multiple tables in power BI?

Hi Sindhu, You can merge the 3 tables ...READ MORE

answered Mar 14, 2019 in Power BI by Cherukuri
• 32,460 points
6,330 views
0 votes
1 answer

How to create action button in Power BI?

Hi Raghav, Follow the below steps: 1. Click on ...READ MORE

answered Jun 20, 2019 in Power BI by Cherukuri
• 32,460 points
3,915 views
0 votes
1 answer

Install Power BI Desktop

It’s a pretty simple process. All you ...READ MORE

answered Oct 9, 2018 in Power BI by Kalgi
• 51,850 points
87 views
0 votes
1 answer

Few tips before I start creating Power BI dashboard

It’s always advisable to begin with the data ...READ MORE

answered Oct 9, 2018 in Power BI by Kalgi
• 51,850 points
112 views
0 votes
1 answer

How do I format the KPI in Power BI

format the KPI by selecting the paint ...READ MORE

answered Oct 9, 2018 in Power BI by Kalgi
• 51,850 points
112 views
+1 vote
1 answer
0 votes
1 answer
0 votes
1 answer

How to Create and use doughnut charts in Power BI?

Hey, To create a doughnut chart in Power ...READ MORE

answered Feb 6 in Power BI by Gitika
• 29,170 points
144 views