Most viewed questions in Power BI

0 votes
1 answer

Calculate age from dob field and another date value using slicer

Hi Karthick, Create a parameter with year range ...READ MORE

May 17, 2019 in Power BI by anonymous
 • 33,030 points • 1,635 views
0 votes
1 answer

Calling Azure API using Power BI with Next Link

Try this let iterations = ...READ MORE

Apr 9, 2019 in Power BI by Shubham
 • 13,490 points • 1,631 views
0 votes
1 answer

Power Query Web request results in “CR must be followed by LF” Error

What I think is, it might look ...READ MORE

Oct 29, 2018 in Power BI by Shubham
 • 13,490 points • 1,629 views
0 votes
1 answer

Error: We couldn't find any data in your Excel workbook

To import from Excel into the Power ...READ MORE

Oct 22, 2020 in Power BI by Gitika
 • 65,910 points • 1,600 views
0 votes
1 answer

Power BI DAX - adding date filter to DAX Query

VALUES('Combination'[Requirement]) gives you a table with all the ...READ MORE

Feb 23, 2022 in Power BI by CoolCoder
 • 4,400 points • 1,596 views
0 votes
1 answer

Using DAX calculation how to calculate monthly budget till today in power bi Desktop?

You can make use of this: MTD Budget ...READ MORE

Sep 24, 2020 in Power BI by Gitika
 • 65,910 points • 1,595 views
+1 vote
1 answer

Connectivity between Control-M and Power BI

There are few new APIs that will allow ...READ MORE

Aug 28, 2020 in Power BI by Rajiv
 • 8,910 points • 1,594 views
0 votes
1 answer

PowerPivot DAX - Dynamic Ranking Per Group (Min Per Group)

Firstly create a basic measure [Amount] to sum the ...READ MORE

Nov 18, 2020 in Power BI by Gitika
 • 65,910 points • 1,581 views
0 votes
1 answer

DAX. Problem with subtotals and grand totals

Create a new measure for the km ...READ MORE

Oct 5, 2020 in Power BI by Gitika
 • 65,910 points • 1,570 views
0 votes
1 answer

Creating a stacked chart from 1 column in Power BI

Hi @Veronicabello, Follow the below steps: 1. Create a ...READ MORE

Aug 3, 2020 in Power BI by Reshma
 • 1,540 views
0 votes
1 answer

​Embed Power BI dashboard tile and make it auto update

This feature is not currently available with ...READ MORE

Sep 28, 2018 in Power BI by Kalgi
 • 52,360 points • 1,540 views
0 votes
1 answer

Dax Calculations on Date&time

Hey, @Vnk, I hope you have a data ...READ MORE

Jun 30, 2020 in Power BI by Gitika
 • 65,910 points • 1,524 views
+1 vote
1 answer

Topic -Power BI Paginated Reports with Excel or CSV file data source

Hi, @There, With Power BI Desktop, you can ...READ MORE

Aug 28, 2020 in Power BI by Carlos
 • 1,508 views
0 votes
1 answer

How do you run R script visual in Power BI Service?

Hi, It seems that your data format not recognized correctly ...READ MORE

May 21, 2019 in Power BI by Avantika
 • 1,520 points
edited May 22, 2019 by Omkar • 1,486 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,620 points • 1,482 views
+7 votes
4 answers

What is Business Intelligence

Business In Intelligence is a set of ...READ MORE

Oct 10, 2018 in Power BI by Kalgi
 • 52,360 points • 1,480 views
+1 vote
1 answer

Connect power bi desktop to dataset and create custom reports

Yes using Power BI REST API to ...READ MORE

Sep 18, 2018 in Power BI by Kalgi
 • 52,360 points • 1,473 views
0 votes
1 answer

count of string in pie chart

Hi Prakash, Select the measure and measure that ...READ MORE

May 7, 2019 in Power BI by Cherukuri
 • 33,030 points • 1,458 views
0 votes
1 answer

Where is OLAP in Power BI

Is there a difference between the data ...READ MORE

Feb 22, 2022 in Power BI by surbhi
 • 3,810 points • 1,449 views
0 votes
1 answer

How to import data model from Excel in PowerBI?

You may try to divide your data ...READ MORE

Oct 22, 2020 in Power BI by anonymous
 • 65,910 points • 1,445 views
0 votes
1 answer

How DAX Difference between naked SUM and sum wrapped in CALCULATE?

This is materially different than the question ...READ MORE

Oct 8, 2020 in Power BI by Gitika
 • 65,910 points • 1,445 views
0 votes
1 answer

DAX formula to concatenate three columns.

If the columns are already text, you ...READ MORE

Oct 1, 2020 in Power BI by Gitika
 • 65,910 points • 1,444 views
0 votes
1 answer

Call Azure API with nextLink (next page) in Power BI

Here is something you could try or ...READ MORE

Nov 12, 2018 in Power BI by Upasana
 • 8,620 points • 1,442 views
0 votes
1 answer

Left Outer Join using DAX in PowerBI.

You can simply write a few measures ...READ MORE

Sep 24, 2020 in Power BI by Gitika
 • 65,910 points • 1,438 views
+1 vote
1 answer

Show the latest value in PowerBi from ASA

Best you can do right now is ...READ MORE

Oct 25, 2018 in Power BI by Surendra
 • 1,429 views
0 votes
1 answer

list reports with calculated percentage in Power BI using dax

Create a Measure called Total Revenue: Total Revenue = SUMX( ...READ MORE

Oct 22, 2018 in Power BI by Hannah
 • 18,570 points • 1,396 views
0 votes
1 answer

Is it possible to use R Plotly library in R Script Visual of Power BI?

For newer versions of PowerBI, it's also ...READ MORE

Dec 8, 2020 in Power BI by Gitika
 • 65,910 points • 1,383 views
0 votes
1 answer

calculation of hourly dax

Hi, @Vnk, Regarding your above query, you can ...READ MORE

Jul 28, 2020 in Power BI by Gitika
 • 65,910 points • 1,383 views
0 votes
1 answer

How many reports can be created in one Power BI reports

You have a limit of 1000 datasets ...READ MORE

Sep 24, 2018 in Power BI by Hannah
 • 18,570 points • 1,372 views
0 votes
1 answer

How to Transpose unique values and get matching values in rows?

I think this query should do what ...READ MORE

Apr 1, 2019 in Power BI by Upasana
 • 8,620 points • 1,354 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
 • 33,030 points • 1,353 views
0 votes
1 answer

Refresh power bi report every hour

You’ll have a Power BI service option ...READ MORE

Sep 24, 2018 in Power BI by Hannah
 • 18,570 points • 1,316 views
0 votes
1 answer

Understanding the DAX CALCULATE function

Using the CALCULATE function makes the DAX perform a context ...READ MORE

Sep 28, 2020 in Power BI by Gitika
 • 65,910 points • 1,313 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,020 points • 1,300 views
0 votes
1 answer

Error Error on Data load when open report in server "An error has occurred"

The problem you can solve by edit this ...READ MORE

Nov 16, 2020 in Power BI by Gitika
 • 65,910 points • 1,298 views
0 votes
1 answer

Query from Power BI to AI suddenly fails with (502): Bad Gateway

The AA Query frequently returns too much ...READ MORE

Feb 10, 2022 in Power BI by CoolCoder
 • 4,400 points • 1,295 views
0 votes
1 answer

Hi, I am learning Power BI and trying to understand how calculate works without filter? = calculate(sum(sales.total_amout)). why cant we give sum(sales.total_amount)?

Hello @Amitha, The CALCULATE function is useful because ...READ MORE

Oct 1, 2020 in Power BI by Roshni
 • 10,520 points • 1,293 views
+1 vote
1 answer

Need a DAX : To check the new escalations arrived, on the change of the escalation counter from zero to one or more

Yes exactly !  i need a measure for ...READ MORE

Sep 3, 2019 in Power BI by anonymous
edited Sep 3, 2019 • 1,291 views
0 votes
1 answer

PowerBI Workspace not visible

Aside from double-checking that the person added ...READ MORE

Mar 14, 2022 in Power BI by gaurav
 • 23,260 points • 1,289 views
+2 votes
0 answers

Assume referential integrity

1) What is Assume referential integrity? what ...READ MORE

Aug 19, 2019 in Power BI by vnk
 • 1,289 views
0 votes
1 answer

How do I label bar graph with different colors based on values from different slicers?

If the user selects only one value ...READ MORE

May 21, 2019 in Power BI by Avantika
 • 1,520 points • 1,273 views
0 votes
1 answer

powerbi embeded in .net core 1.1

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

Nov 28, 2018 in Power BI by Upasana
 • 8,620 points • 1,255 views
+1 vote
0 answers

Profit & Loss DAX table help

Below shows the report I am working ...READ MORE

Aug 6, 2019 in Power BI by John
 • 130 points • 1,225 views
0 votes
1 answer

How do you add a new filter pane in old Power BI reports?

Hi, You can perform the following steps: 1. Open ...READ MORE

May 22, 2019 in Power BI by Avantika
 • 1,520 points • 1,216 views
0 votes
1 answer

How to add an image to power bi report – power bi web

There are visuals (e.g. table) that can ...READ MORE

Sep 27, 2018 in Power BI by Kalgi
 • 52,360 points • 1,212 views
0 votes
1 answer

PowerBI - Actual & Planned Dates on Same X Axis

Yes, you may add two date columns ...READ MORE

Feb 15, 2022 in Power BI by CoolCoder
 • 4,400 points • 1,199 views
+2 votes
2 answers

Migrate power bi collection to power bi embedded

I agree with Kalgi, this method is ...READ MORE

Oct 11, 2018 in Power BI by Hannah
 • 18,570 points • 1,197 views
0 votes
1 answer

DAX Power BI: Replaced blank values with zero and issue with chart

It seems like you're facing an issue ...READ MORE

Aug 22, 2023 in Power BI by anonymous
 • 1,380 points • 1,196 views
0 votes
0 answers

How to break datetime field to date field in power bi?

How to break DateTime field to date ...READ MORE

Oct 18, 2019 in Power BI by ch
 • 3,450 points • 1,195 views
0 votes
1 answer

Find number of days between 2 dates.

Hi Sindhu, Create a column with below code. ...READ MORE

Apr 8, 2019 in Power BI by Cherukuri
 • 33,030 points • 1,186 views
Page:

Most popular tags

"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.