Latest questions in Power BI

0 votes
1 answer

Append excel data and In house database data that gets refresh evey 24 hour

Hi, You can try this way, A  -  Actual ...READ MORE

Mar 20, 2019 in Power BI by Sindhu
35 views
0 votes
1 answer

How can I get a column value from previous row in Power Query?

Hi Sindhu, add this line as your ...READ MORE

Mar 18, 2019 in Power BI by Cherukuri
• 32,420 points
1,719 views
0 votes
1 answer

How to calculate cumulative Total and % in DAX?

Hi, If your table is ready with percentage ...READ MORE

Mar 18, 2019 in Power BI by Cherukuri
• 32,420 points
3,245 views
+1 vote
1 answer

Power BI: TopN and All Other

Hi , Create a measure to calculate rank ...READ MORE

Mar 18, 2019 in Power BI by Cherukuri
• 32,420 points
1,181 views
0 votes
1 answer

Add Column Count_of_people across two tables to get the count of people from a city.

Hi Anitha, 1. Merge both tables, using City ...READ MORE

Mar 22, 2019 in Power BI by Cherukuri
• 32,420 points
49 views
0 votes
1 answer

How to combine multiple tables in power BI?

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

Mar 14, 2019 in Power BI by Cherukuri
• 32,420 points
2,645 views
0 votes
1 answer

Calculated column with the sum of values from many columns in a row

Hi, You can create a new column by ...READ MORE

Mar 14, 2019 in Power BI by Cherukuri
• 32,420 points
82 views
0 votes
1 answer

Count occurrences in DAX

You can use DAX functions to do ...READ MORE

Mar 9, 2019 in Power BI by Avantika
• 1,500 points
2,656 views
0 votes
1 answer

How do you create a link visual in Power BI?

You can easily create a link between ...READ MORE

Mar 8, 2019 in Power BI by Avantika
• 1,500 points

edited Mar 9, 2019 by Avantika 97 views
0 votes
1 answer

Combining field values to create an additional field?

Hi Nithin, 1. Go to Power Query Editor, ...READ MORE

Mar 8, 2019 in Power BI by Cherukuri
• 32,420 points
50 views
+3 votes
1 answer

How to replace null values with custom values in Power BI(power query editor)?

Hi Nithin, To fill or replace the null or ...READ MORE

Mar 8, 2019 in Power BI by Cherukuri
• 32,420 points
10,830 views
0 votes
1 answer

How do you embed dashboard using JavaScript in Power BI?

Dashboards in Power BI can be embedded ...READ MORE

Mar 5, 2019 in Power BI by Phalguni
• 1,010 points
133 views
0 votes
1 answer

How do you add a slicer from different table in Power BI?

In order to add a slicer from ...READ MORE

Mar 5, 2019 in Power BI by Phalguni
• 1,010 points
151 views
0 votes
1 answer

How to add slicer from a different tables?

Hi, Join is normally performed to get ...READ MORE

Mar 1, 2019 in Power BI by Cherukuri
• 32,420 points
624 views
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

Mar 1, 2019 in Power BI by Cherukuri
• 32,420 points
697 views
0 votes
1 answer

How to Install Power BI in Windows

Hi, Anitha Go to this Link https://powerbi.microsoft.com/en-us/downloads/ Then click on ...READ MORE

Feb 28, 2019 in Power BI by Cherukuri
• 32,420 points
59 views
0 votes
1 answer

Calculating MoM Variance of a Measure Field using DAX

Create an intermediate calculated column that considers ...READ MORE

Feb 28, 2019 in Power BI by Shubham
• 13,370 points
1,426 views
0 votes
1 answer

Calculate Total number of Male & Female in the PowerBI report

To achieve what you are looking for, ...READ MORE

Feb 28, 2019 in Power BI by Upasana
• 8,570 points
857 views
0 votes
1 answer

How to combine your data or tables in Power BI?

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

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

How do you create visualizations in Power BI?

Visualizations in Power BI Visuals are the end-result ...READ MORE

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

PowerQuery : How can I reference a cell's value?

You can do so using a named ...READ MORE

Feb 27, 2019 in Power BI by Shubham
• 13,370 points
1,893 views
0 votes
1 answer

How can I concatenate grouped values in PowerQuery ?

If your table is Source, and if ...READ MORE

Feb 27, 2019 in Power BI by Shubham
• 13,370 points
465 views
0 votes
1 answer

To expand all lists in a row of lists at the same time without recurring values

Can't promise simple, but I have something ...READ MORE

Feb 19, 2019 in Power BI by Upasana
• 8,570 points
494 views
0 votes
1 answer

Replace “yes” found in one list with the actual string from another list

Objective : The idea is to use List.Transform twice, ...READ MORE

Feb 19, 2019 in Power BI by Upasana
• 8,570 points
57 views
0 votes
1 answer

Power Query : making HTTP POST request with form data

Try Using Uri.BuildQueryString and Json.Document let ...READ MORE

Feb 14, 2019 in Power BI by Upasana
• 8,570 points
359 views
0 votes
1 answer

Power Query : Adding Columns and Multiple files

The following call, FirstRowAsHeader = Table.PromoteHeaders(TableWithoutHeader) shall replace the ...READ MORE

Feb 14, 2019 in Power BI by Upasana
• 8,570 points
50 views
0 votes
2 answers

Using R packages in Power BI

You can use the powerful R programming language to ...READ MORE

Feb 8, 2019 in Power BI by rajesh
• 1,210 points
51 views
0 votes
1 answer

Bar chart : Arranging in descending order using data from another chart

Select treemap.  Make it active.  Turn on Visual Interactions ...READ MORE

Feb 7, 2019 in Power BI by Upasana
• 8,570 points
30 views
0 votes
1 answer

Power BI Service : System.Object type is not supported

You have to modify the stream analytics ...READ MORE

Feb 6, 2019 in Power BI by Shubham
• 13,370 points
47 views
0 votes
1 answer

Power Query: Split Column by field lengths

Start by creating a query with the ...READ MORE

Jan 30, 2019 in Power BI by Upasana
• 8,570 points
349 views
0 votes
1 answer

Looping in Power Query

In Power Query, you often find a ...READ MORE

Jan 30, 2019 in Power BI by Upasana
• 8,570 points
600 views
0 votes
2 answers

Power BI : Case Sensitivity

Oracle DB specific workaround, For Dimension & Fact ...READ MORE

Apr 26, 2019 in Power BI by Mahendra
326 views
0 votes
1 answer

Locating closest match based on Latitude & Longitude

First of all, we need to use the ...READ MORE

Jan 2, 2019 in Power BI by Shubham
• 13,370 points
257 views
0 votes
1 answer

.Net Core 1.1 : Power BI Embedded

Hope this might be of some help ...READ MORE

Dec 27, 2018 in Power BI by Upasana
• 8,570 points
58 views
0 votes
1 answer

Power Query: Adding a Special Case

Try adding a Group By with Minimum ...READ MORE

Dec 27, 2018 in Power BI by Upasana
• 8,570 points
61 views
0 votes
1 answer

Using R packages in Power BI

When you're trying to use R on ...READ MORE

Dec 17, 2018 in Power BI by Shubham
• 13,370 points
62 views
0 votes
1 answer

Using Treemap as a filter

What you want is possible using the ...READ MORE

Dec 17, 2018 in Power BI by Shubham
• 13,370 points
590 views
0 votes
1 answer

Power BI Using SQL Server stored procedures

NOTE: The following works for the "Import ...READ MORE

Dec 14, 2018 in Power BI by Upasana
• 8,570 points
2,317 views
0 votes
1 answer

Power BI Desktop : Npgsql 3.0.3 error

You can fix this issue by installing the ...READ MORE

Dec 14, 2018 in Power BI by Upasana
• 8,570 points
109 views
0 votes
1 answer

Power Query : http POST request with form data

Try using Uri.BuildQueryString and Json.Document. let ...READ MORE

Dec 12, 2018 in Power BI by Upasana
• 8,570 points
1,927 views
0 votes
1 answer

Power Query: Custom Columns

This call: FirstRowAsHeader = Table.PromoteHeaders(TableWithoutHeader) replaces the column names ...READ MORE

Dec 12, 2018 in Power BI by Upasana
• 8,570 points
60 views
0 votes
1 answer

How to load file to Excel Power query from SFTP site

Currently, I don't think there is a ...READ MORE

Dec 3, 2018 in Power BI by Upasana
• 8,570 points
399 views
0 votes
1 answer

Pivot table drill down functionality in Power BI

There is a clear deficit in the ...READ MORE

Dec 3, 2018 in Power BI by Upasana
• 8,570 points
867 views
0 votes
1 answer

Power BI : Creating time factors

Go to Edit Queries window of Power BI Desktop. ...READ MORE

Nov 30, 2018 in Power BI by Shubham
• 13,370 points
78 views
0 votes
1 answer

Embedding a dashboard using Java in Power BI

Make sure to use the correct embedURL, ...READ MORE

Nov 30, 2018 in Power BI by Shubham
• 13,370 points
1,061 views
0 votes
1 answer

Many to many relationship in BI

This is an error in the documentation.  As ...READ MORE

Nov 28, 2018 in Power BI by Upasana
• 8,570 points
38 views
0 votes
1 answer

powerbi embeded in .net core 1.1

See if it helps: https://www.nuget.org/packages/PowerBI.NetStandard ...READ MORE

Nov 28, 2018 in Power BI by Upasana
• 8,570 points
126 views
0 votes
1 answer

Power BI : npgsql installation

As a general rule Npgsql can be ...READ MORE

Nov 27, 2018 in Power BI by Shubham
• 13,370 points
417 views
0 votes
1 answer

Power BI : text case changing automatically

Power BI doesn't handle case sensitivity that ...READ MORE

Nov 27, 2018 in Power BI by Shubham
• 13,370 points
40 views
0 votes
1 answer

To Calculate the Standard Deviation in Power BI

Suppose you've to obtain the Standard Deviation ...READ MORE

Nov 26, 2018 in Power BI by Upasana
• 8,570 points
3,352 views