Most voted questions in Power BI

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
528 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
894 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
467 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 492 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,192 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
664 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,435 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
538 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
393 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
391 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
366 views
0 votes
1 answer

How do I calculate difference between consecutive rows and columns?

There are two ways through which you ...READ MORE

May 21, 2019 in Power BI by Avantika
• 1,520 points
11,617 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,214 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
250 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
429 views
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,587 views
0 votes
1 answer

Give constant values to a column or field

Hi Priyanka, You can use a measure to ...READ MORE

May 17, 2019 in Power BI by anonymous
• 33,030 points
1,720 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
771 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
368 views
0 votes
1 answer

Difference between measure and calculate column in power BI

Hi Rahul,  With calculated columns, you can add new ...READ MORE

May 17, 2019 in Power BI by Cherukuri
• 33,030 points
10,269 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
465 views
0 votes
1 answer

How to sum a data table in Power BI?

It's a good practice if you avoid ...READ MORE

May 17, 2019 in Power BI by Avantika
• 1,520 points

edited May 17, 2019 by Omkar 7,069 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
480 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
399 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
430 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
417 views
0 votes
1 answer

How to categorize state, pin and city in power bi (Address)

After loading dataset, you can split in ...READ MORE

May 10, 2019 in Power BI by anonymous
• 33,030 points
2,922 views
0 votes
1 answer

show data even for no data - power BI

Hi Latha, To show rows with empty data ...READ MORE

May 9, 2019 in Power BI by Cherukuri
• 33,030 points
18,922 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
303 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
595 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
601 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
454 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
478 views
0 votes
1 answer

Datediff with column having no value/ blank

Hi Karthick, Use the below DAX code - ...READ MORE

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

Multiple slicer using same field

Hi Anitha, You can use the same filed ...READ MORE

May 8, 2019 in Power BI by Cherukuri
• 33,030 points
4,783 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
378 views
0 votes
1 answer

all and allExcept - DAX functions

Hi Satish, All function is used when you ...READ MORE

May 7, 2019 in Power BI by Cherukuri
• 33,030 points
6,238 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
365 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,402 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,286 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,167 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
646 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,012 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
651 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
842 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
505 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
328 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,096 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
940 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,926 views