Trending 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,879 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,517 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,573 views
0 votes
1 answer

How to Export data in Power BI online version?

Hi, You can export your data from any ...READ MORE

May 27, 2019 in Power BI by Avantika
 • 1,520 points • 1,189 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 • 2,318 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,728 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 • 3,253 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
 • 33,030 points • 4,565 views
0 votes
1 answer

How do you add a new column with the calculated result?

Hi, You can do this with the help ...READ MORE

May 27, 2019 in Power BI by Avantika
 • 1,520 points • 788 views
0 votes
0 answers

How do you create a relationship between two queries with same database?

I have some database view with several ...READ MORE

May 28, 2019 in Power BI by Phalguni
 • 1,020 points • 771 views
0 votes
1 answer

How do you schedule Data Refresh in Power BI?

Hi, Following could be the reasons why this ...READ MORE

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

How to show sub total to sub groups along with individual values?

Hi Lassya, Follow the below steps: 1. Right click ...READ MORE

May 21, 2019 in Power BI by anonymous
 • 33,030 points • 950 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,620 points • 5,699 views
0 votes
1 answer

How do I add a filter and a slicer?

Hi, Its OLTP and DW modeling. However, you ...READ MORE

May 23, 2019 in Power BI by Avantika
 • 1,520 points
edited May 23, 2019 by Omkar • 855 views
0 votes
1 answer

Use Measure/ column to replace text

Hi Nithin, For example, to replace null or ...READ MORE

May 17, 2019 in Power BI by Cherukuri
 • 33,030 points • 1,037 views
+1 vote
1 answer

Why doesn't the KPI refreshes in Power BI?

You would have to most probably change the ...READ MORE

May 15, 2019 in Power BI by Avantika
 • 1,520 points
edited May 15, 2019 by Omkar • 1,095 views
0 votes
1 answer

Replace and Round

Hey Anshuli, Create a column as below, Column = ...READ MORE

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

End with characters in column

Hi Rahul, You can use condition such as ...READ MORE

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

Starts with characters in column

Hi Rahul, You can use condition such as ...READ MORE

May 21, 2019 in Power BI by anonymous
 • 33,030 points • 649 views
0 votes
0 answers

Max rank among set of sub category

How to show the maximum rank under ...READ MORE

May 17, 2019 in Power BI by radha
 • 845 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,415 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 • 2,356 views
0 votes
1 answer

Conditional Formatting - Power BI

Hi Priya, Create a parameter and add it ...READ MORE

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

Can i show data for one variable for a field without using slicer?

Hi Pranav, Yes, you can perform the calculation ...READ MORE

May 16, 2019 in Power BI by Cherukuri
 • 33,030 points • 733 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 • 1,308 views
0 votes
1 answer

how can I connect my web api with Power BI Reports?

Go to Home > Edit Queries > ...READ MORE

Oct 18, 2018 in Power BI by Annie97
 • 2,160 points • 9,758 views
0 votes
1 answer

Measure to filter date from another field

Hi, Create a column with [date-field].[month] to fetch ...READ MORE

May 17, 2019 in Power BI by Cherukuri
 • 33,030 points • 607 views
0 votes
0 answers

Average of 3 Months

hi, how to calculate the average for ...READ MORE

May 20, 2019 in Power BI by sindhu
 • 460 views
0 votes
1 answer

Why does a reference to a value in previous row throw this Expression.Error?

If you have multiple steps after the ...READ MORE

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

How do I create a line chart?

Hi, From the data mentioned above, you can ...READ MORE

May 10, 2019 in Power BI by Avantika
 • 1,520 points • 799 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 • 1,399 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,490 points • 7,848 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 • 2,094 views
0 votes
1 answer

Count - using If within period of dates.

Hi Sindhu, Use below DAX code to create ...READ MORE

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

How do you change the tables in chart filters?

Hi, You can use the following measure. Measure 2 = ...READ MORE

May 10, 2019 in Power BI by Avantika
 • 1,520 points • 687 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 • 1,000 views
0 votes
0 answers

How do you change the tables in chart filters?

I am working on a report that shows ...READ MORE

May 10, 2019 in Power BI by anonymous
 • 687 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 • 970 views
0 votes
1 answer

Difference between the number of days user(client) has logged into the website.

Hi Rajesh, Use below code -  Column 4 = ...READ MORE

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

append a column to another column

Hi Priya, You can use concatenate to join ...READ MORE

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

conditional formatting - color to show few rows from acndition

Hi Priya, Create a matrix with region and ...READ MORE

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

Text into URL

Hi Riya, To convert a URL or hyperlink text ...READ MORE

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

dates in power bi

Hi Raju, You can show visual for a ...READ MORE

May 7, 2019 in Power BI by Cherukuri
 • 33,030 points • 580 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 • 755 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,794 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 • 618 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,490 points • 3,344 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,488 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,620 points • 6,398 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,020 points • 3,105 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.