How to create Pivot Tables in Power BI

0 votes
Can anyone specify how to create Pivot tables in Power BI?
Feb 6, 2020 in Power BI by Roshni
• 10,400 points
1,668 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, 2020 by Gitika
• 65,850 points

Related Questions In Power BI

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,020 points
807 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,890 points
10,291 views
0 votes
1 answer

how to create snapshots in power BI?

Snapshots enable faster loading of specific properties. Follow ...READ MORE

answered Oct 29, 2019 in Power BI by Cherukuri
• 32,890 points
4,651 views
0 votes
1 answer

How to create a relative data slicer in Power BI?

Hi, With the relative date slicer or filter, you ...READ MORE

answered Jan 31, 2020 in Power BI by Shivani
684 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
• 52,290 points
188 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
• 52,290 points
159 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
• 52,290 points
195 views
+1 vote
1 answer
0 votes
3 answers

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

To do so, follow these steps: From the ...READ MORE

answered Dec 16, 2020 in Power BI by Gitika
• 65,850 points
12,419 views
0 votes
4 answers

How to combine multiple tables in power BI?

Click Advanced Editor and check if step #"Appended ...READ MORE

answered Dec 16, 2020 in Power BI by Roshni
• 10,400 points
15,219 views