Most answered questions in Power BI

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,449 views
0 votes
1 answer

How To use R Integration in Power BI?

Hi,  There are a lot of packages available ...READ MORE

May 3, 2019 in Power BI by Avantika
 • 1,520 points • 2,360 views
0 votes
1 answer

How do I use Python scripts in Power BI?

Hi, You can create interactive reports out of ...READ MORE

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

calculation with condition and filter

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

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

Create custom tables in power BI

Hi Sindhu, You can create custom tables by clicking ...READ MORE

May 2, 2019 in Power BI by Cherukuri
 • 33,030 points • 13,258 views
0 votes
1 answer

Rank - Power BI

Hi Anitha, Drop Category, product-id, and sales into ...READ MORE

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

Total sales for orders till current date using MTD

Hi Riya, Use the below code to find ...READ MORE

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

Most recent order sales from customers

Hi Nithin, You can use LASTDATE() to fetch ...READ MORE

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

Top N - Power BI

Hi Priya, You can use Rank () or ...READ MORE

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

Calculate and filter function - DAX

Hi Praneeth, Calculate () by default perform calculations ...READ MORE

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

Power BI : Status Count

Try COUNT, COUNTX, or COUNTROWS . READ MORE

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

To calculate conditional running total in power query

Try Table Buffer after adding the index, or ...READ MORE

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

How to use Python Scripts in Query Editor?

Hi, In order to use Python Visuals you need ...READ MORE

Apr 11, 2019 in Power BI by Avantika
 • 1,520 points • 3,372 views
0 votes
1 answer

How do you use R visuals in Power BI Desktop?

Hi, In order to use R Visuals you ...READ MORE

Apr 10, 2019 in Power BI by Avantika
 • 1,520 points • 465 views
0 votes
1 answer

Count of Id within another Id

Hi Kalyan, Follow below steps: 1. Create a slicer ...READ MORE

Apr 17, 2019 in Power BI by Cherukuri
 • 33,030 points • 463 views
0 votes
1 answer

Adding values of two columns in two tables

Hi Anshuli, You can either create a separate ...READ MORE

Apr 10, 2019 in Power BI by Cherukuri
 • 33,030 points • 1,038 views
0 votes
1 answer

count of orders on n hour basis - Power BI

Hi Nithin, You can create a measure to ...READ MORE

Apr 11, 2019 in Power BI by Cherukuri
 • 33,030 points • 727 views
0 votes
1 answer

Chart with only some values in field in a graph in power BI?

Hi Banu, While creating a chart, put the ...READ MORE

Apr 10, 2019 in Power BI by Cherukuri
 • 33,030 points • 723 views
0 votes
1 answer

Power BI Embedded: DMTS_DatasourceHasNoCredentialError

You'll need to call the PATCH data source API Patch Gateway ...READ MORE

Apr 10, 2019 in Power BI by Shubham
 • 13,490 points • 1,833 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,618 views
0 votes
1 answer

How do I use Python Visualizations in Power BI?

Hi, You can create interactive reports out of ...READ MORE

Apr 8, 2019 in Power BI by Phalguni
 • 1,020 points • 680 views
0 votes
1 answer

add bar colors in power bi under condition

Hi Sindhu, Follow below steps to add colors ...READ MORE

Apr 8, 2019 in Power BI by Cherukuri
 • 33,030 points • 352 views
0 votes
1 answer

Show orders from past n months

Hi banu, Create a column like below, diff = DATEDIFF(Orders[Order ...READ MORE

Apr 8, 2019 in Power BI by Cherukuri
 • 33,030 points • 415 views
0 votes
1 answer

Show orders from past n days in Power BI?

HI banu, Create a column like below, diff = ...READ MORE

Apr 8, 2019 in Power BI by Cherukuri
 • 33,030 points • 630 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,178 views
0 votes
1 answer

Power BI : Counting Failures

Try the following measure: Count of fails = ...READ MORE

Apr 5, 2019 in Power BI by Upasana
 • 8,620 points • 1,024 views
0 votes
1 answer

Power BI getting 2 week back same day value

You can use DATEADD() function to compute the 14 ...READ MORE

Apr 5, 2019 in Power BI by Upasana
 • 8,620 points • 1,063 views
0 votes
1 answer

Dax: Sum of values from many columns in a row

Yes, you can. Try to "Unpivot other columns" ...READ MORE

Apr 3, 2019 in Power BI by Upasana
 • 8,620 points • 9,790 views
0 votes
1 answer

Power BI Embedded : Importing Packages

This should help you out. https://www.nuget.org/packages/PowerBI.N ...READ MORE

Apr 3, 2019 in Power BI by Shubham
 • 13,490 points • 489 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,341 views
0 votes
1 answer

Cumulative row data over last 12 months in Power Query

Basically, what you do is,  Add an Index,  Group ...READ MORE

Apr 1, 2019 in Power BI by Upasana
 • 8,620 points • 2,705 views
0 votes
1 answer

How do I convert month format in Power BI?

Hi, This can easily be done using DAX ...READ MORE

Mar 27, 2019 in Power BI by Avantika
 • 1,520 points • 4,635 views
0 votes
1 answer

How to add multiple reference lines on a bar/ column graph?

Hi, Follow below steps: 1. Add a bar/ column ...READ MORE

Mar 26, 2019 in Power BI by Cherukuri
 • 33,030 points • 8,153 views
0 votes
1 answer

How to show filtered vs total data in power BI?

Hi sindhu, Follow below steps to show filtered ...READ MORE

Mar 26, 2019 in Power BI by Cherukuri
 • 33,030 points • 4,311 views
0 votes
1 answer

Power BI - How to make groups?

hi Nithin, Follow these steps to create groups: 1. ...READ MORE

Mar 26, 2019 in Power BI by Cherukuri
 • 33,030 points • 431 views
0 votes
1 answer

Power BI- How to make a waterfall chart?

Hi Nithin, Follow these steps to make a ...READ MORE

Mar 26, 2019 in Power BI by Cherukuri
 • 33,030 points • 1,090 views
0 votes
1 answer

Power BI - Amazon RedShift

Hi,  Follow these steps, to connect to Amazon ...READ MORE

Mar 25, 2019 in Power BI by Cherukuri
 • 33,030 points • 874 views
0 votes
1 answer

Power BI - Postgresql

Hi,  Follow these steps, to connect to Postgresql database.  1. ...READ MORE

Mar 25, 2019 in Power BI by Cherukuri
 • 33,030 points • 434 views
0 votes
1 answer

Power BI - Azure SQL Warehouse

Hi, Follow below steps: 1. Go to Data source. 2. Go ...READ MORE

Mar 25, 2019 in Power BI by Cherukuri
 • 33,030 points • 511 views
0 votes
1 answer

Power BI - Salesforce

Hi, Follow below steps: 1. Go to Data source. 2. ...READ MORE

Mar 25, 2019 in Power BI by Cherukuri
 • 33,030 points • 495 views
0 votes
1 answer

How to connect to sql server from power Bi?

Hi, Follow these steps to connect to SQL ...READ MORE

Mar 22, 2019 in Power BI by Cherukuri
 • 33,030 points • 1,128 views
+2 votes
1 answer

How to connect to mysql database from power Bi?

Hi, Follow these steps, to connect to MYSQL ...READ MORE

Mar 22, 2019 in Power BI by Cherukuri
 • 33,030 points • 25,143 views
0 votes
1 answer

How to connect to IBM DB2 database from power Bi?

Hi, Hi, Follow these steps, to connect to IBM ...READ MORE

Mar 22, 2019 in Power BI by Cherukuri
 • 33,030 points • 11,352 views
0 votes
1 answer

How to connect to sap Hana database from power Bi?

Hi, Follow these steps to connect to data ...READ MORE

Mar 22, 2019 in Power BI by Cherukuri
 • 33,030 points • 7,161 views
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
 • 534 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
 • 33,030 points • 7,671 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
 • 33,030 points • 18,416 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
 • 33,030 points • 5,633 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
 • 33,030 points • 827 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
 • 33,030 points • 2,221 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.