Trending 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,050 points
1,854 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,050 points
4,701 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
915 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,154 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
869 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,050 points
1,073 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,845 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 982 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,050 points
1,159 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,203 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,050 points
797 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,050 points
783 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,544 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,050 points
743 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
954 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,050 points
1,541 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,050 points
1,229 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,050 points
861 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,927 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,050 points
1,420 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,050 points
730 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
8,029 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
1,009 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,526 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
918 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
527 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,230 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
805 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,050 points
871 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
791 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,050 points
1,086 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,050 points
1,074 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,050 points
767 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,050 points
772 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,050 points
734 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,050 points
629 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,050 points
662 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,050 points
867 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,050 points
2,981 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,050 points
723 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,490 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,050 points
1,637 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,570 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,050 points
1,330 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,260 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,622 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,588 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,050 points
1,457 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,683 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,050 points
1,230 views