Trending questions in Power BI

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
249 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
473 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
• 27,960 points
22 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
73 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
• 27,960 points
49 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
37 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
• 27,960 points
35 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
• 27,960 points
22 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
65 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 in Power BI by Cherukuri
• 27,960 points
1,128 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
37 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
• 27,960 points
19 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
• 27,960 points
17 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
• 27,960 points
18 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
• 27,960 points
16 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
• 27,960 points
750 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
287 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
• 27,960 points
711 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
18 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
14 views
0 votes
1 answer

Count occurrences in DAX

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

Mar 9 in Power BI by Avantika
• 1,500 points
1,190 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
24 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
• 27,960 points
661 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
68 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
• 27,960 points
662 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
• 27,960 points
150 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
101 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
• 27,960 points
143 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
• 27,960 points
81 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
• 27,960 points
78 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
• 27,960 points
52 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
• 27,960 points
42 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
• 27,960 points
31 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
• 27,960 points
23 views
0 votes
1 answer

Distinct count filtered by condition using Power BI Dax

Try this, it should work: DistinctCountActiveMonths = CALCULATE( ...READ MORE

Oct 5, 2018 in Power BI by Kalgi
• 41,470 points
7,396 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
• 27,960 points
83 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
28 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
• 27,960 points
30 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 in Power BI by Shubham
• 13,300 points
773 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 in Power BI by Cherukuri
• 27,960 points
46 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 in Power BI by Shubham
• 13,300 points
558 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 in Power BI by Upasana
• 8,530 points
505 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 in Power BI by Avantika
• 1,500 points

edited Mar 9 by Avantika 72 views
0 votes
1 answer

How to add slicer from a different tables?

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

Mar 1 in Power BI by Cherukuri
• 27,960 points
364 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 in Power BI by Cherukuri
• 27,960 points
26 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 in Power BI by Phalguni
• 1,010 points
100 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 in Power BI by Phalguni
• 1,010 points
93 views
0 votes
2 answers

Power BI : Case Sensitivity

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

Apr 26 in Power BI by Mahendra
203 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 in Power BI by Cherukuri
• 27,960 points
188 views
0 votes
1 answer

How can I concatenate grouped values in PowerQuery ?

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

Feb 27 in Power BI by Shubham
• 13,300 points
245 views