Most answered questions in Power BI

0 votes
1 answer

How To use R Integration in Power BI?

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

May 2 in Power BI by Avantika
• 1,500 points
162 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 in Power BI by Avantika
• 1,500 points
235 views
0 votes
1 answer

calculation with condition and filter

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

May 2 in Power BI by Cherukuri
• 31,840 points
28 views
0 votes
1 answer

Create custom tables in power BI

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

May 2 in Power BI by Cherukuri
• 31,840 points
25 views
0 votes
1 answer

Rank - Power BI

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

May 2 in Power BI by Cherukuri
• 31,840 points
33 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 in Power BI by Cherukuri
• 31,840 points
35 views
0 votes
1 answer

Most recent order sales from customers

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

May 2 in Power BI by Cherukuri
• 31,840 points
27 views
0 votes
1 answer

Top N - Power BI

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

May 2 in Power BI by Cherukuri
• 31,840 points
19 views
0 votes
1 answer

Calculate and filter function - DAX

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

May 2 in Power BI by Cherukuri
• 31,840 points
39 views
0 votes
1 answer

Power BI : Status Count

Try COUNT, COUNTX, or COUNTROWS . READ MORE

Apr 26 in Power BI by Shubham
• 13,300 points
41 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 in Power BI by Shubham
• 13,300 points
222 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 10 in Power BI by Avantika
• 1,500 points
322 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 in Power BI by Avantika
• 1,500 points
41 views
0 votes
1 answer

Count of Id within another Id

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

Apr 17 in Power BI by Cherukuri
• 31,840 points
27 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 in Power BI by Cherukuri
• 31,840 points
25 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 10 in Power BI by Cherukuri
• 31,840 points
51 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 in Power BI by Cherukuri
• 31,840 points
43 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 in Power BI by Shubham
• 13,300 points
80 views
0 votes
1 answer

Can I get rid of the grey border on the report visuals with power bi embedded?

You can do the following to make the ...READ MORE

Apr 10 in Power BI by Shubham
• 13,300 points
346 views
0 votes
1 answer

Calling Azure API using Power BI with Next Link

Try this let iterations = ...READ MORE

Apr 8 in Power BI by Shubham
• 13,300 points
44 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 in Power BI by Phalguni
• 1,010 points
72 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 in Power BI by Cherukuri
• 31,840 points
20 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 in Power BI by Cherukuri
• 31,840 points
21 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 in Power BI by Cherukuri
• 31,840 points
19 views
0 votes
1 answer

Find number of days between 2 dates.

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

Apr 8 in Power BI by Cherukuri
• 31,840 points
18 views
0 votes
1 answer

Power BI : Counting Failures

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

Apr 5 in Power BI by Upasana
• 8,530 points
22 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 in Power BI by Upasana
• 8,530 points
17 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 in Power BI by Upasana
• 8,530 points
669 views
0 votes
1 answer

Power BI Embedded : Importing Packages

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

Apr 3 in Power BI by Shubham
• 13,300 points
27 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 in Power BI by Upasana
• 8,530 points
81 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 in Power BI by Upasana
• 8,530 points
350 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 26 in Power BI by Avantika
• 1,500 points
181 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 in Power BI by Cherukuri
• 31,840 points
184 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 in Power BI by Cherukuri
• 31,840 points
87 views
0 votes
1 answer

Power BI - How to make groups?

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

Mar 26 in Power BI by Cherukuri
• 31,840 points
54 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 in Power BI by Cherukuri
• 31,840 points
89 views
0 votes
1 answer

Power BI - Amazon RedShift

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

Mar 25 in Power BI by Cherukuri
• 31,840 points
168 views
0 votes
1 answer

Power BI - Postgresql

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

Mar 25 in Power BI by Cherukuri
• 31,840 points
34 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 in Power BI by Cherukuri
• 31,840 points
24 views
0 votes
1 answer

Power BI - Salesforce

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

Mar 25 in Power BI by Cherukuri
• 31,840 points
44 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 in Power BI by Cherukuri
• 31,840 points
97 views
0 votes
1 answer

How to connect to mysql database from power Bi?

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

Mar 22 in Power BI by Cherukuri
• 31,840 points
1,913 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 in Power BI by Cherukuri
• 31,840 points
899 views
0 votes
1 answer

How to connect to oracle database from power Bi?

Hi, 1. Click on Get Data. 2. Go to ...READ MORE

Mar 22 in Power BI by Cherukuri
• 31,840 points
1,784 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 in Power BI by Cherukuri
• 31,840 points
871 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 in Power BI by Sindhu
29 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 in Power BI by Cherukuri
• 31,840 points
947 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 in Power BI by Cherukuri
• 31,840 points
1,918 views
+1 vote
1 answer

Power BI: TopN and All Other

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

Mar 18 in Power BI by Cherukuri
• 31,840 points
789 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 in Power BI by Cherukuri
• 31,840 points
35 views