Trending questions in Power BI

+1 vote
1 answer

How to resolve Power BI DAX Join error?

Sample Table Used Here: Table1: Partner_ID, User_Id Table2: User_Id, ...READ MORE

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

edited May 15, 2019 by Omkar 4,278 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, 2019 in Power BI by Shubham
• 13,490 points
7,343 views
+1 vote
1 answer

Power BI: TopN and All Other

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

Mar 18, 2019 in Power BI by Cherukuri
• 33,050 points
6,403 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,050 points
3,802 views
+1 vote
0 answers

store images from a power publish report in db and call those images

Hi Experts What is the best way to ...READ MORE

Jul 3, 2019 in Power BI by Parminder
• 130 points
1,067 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 27, 2019 in Power BI by Avantika
• 1,520 points
5,252 views
0 votes
1 answer

Setup Python with Power BI.

Follow the below steps: 1. Install python in ...READ MORE

Jun 21, 2019 in Power BI by Cherukuri
• 33,050 points
1,448 views
0 votes
1 answer

To expand all lists in a row of lists at the same time without recurring values

Can't promise simple, but I have something ...READ MORE

Feb 19, 2019 in Power BI by Upasana
• 8,620 points
6,508 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, 2019 in Power BI by Cherukuri
• 33,050 points
4,976 views
0 votes
1 answer

Share Power BI Reports

To be able to share Power BI ...READ MORE

Jun 20, 2019 in Power BI by Cherukuri
• 33,050 points
1,073 views
0 votes
0 answers

How to create a custom column for comparing between of 2 numbers?

Hi How do I create a custom ...READ MORE

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

How to refresh a gateway running on Azure VM?

You can easily resolve this error by ...READ MORE

Jun 10, 2019 in Power BI by Avantika
• 1,520 points
1,429 views
0 votes
1 answer

Power Query : making HTTP POST request with form data

Try Using Uri.BuildQueryString and Json.Document let ...READ MORE

Feb 14, 2019 in Power BI by Upasana
• 8,620 points
6,335 views
0 votes
1 answer

Power Query : http POST request with form data

Try using Uri.BuildQueryString and Json.Document. let ...READ MORE

Dec 12, 2018 in Power BI by Upasana
• 8,620 points
9,085 views
0 votes
1 answer

Power BI integration with R

Follow the below steps: 1. Install R in your ...READ MORE

Jun 21, 2019 in Power BI by Cherukuri
• 33,050 points
849 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,050 points
2,277 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 11, 2019 in Power BI by Avantika
• 1,520 points
3,774 views
0 votes
1 answer

How do I show more than one data element in a 'card'?

Hi, In order to show more than one ...READ MORE

Jun 14, 2019 in Power BI by Avantika
• 1,520 points
991 views
0 votes
0 answers

Create a sample report in power BI using R script

how to create a sample chart using ...READ MORE

Jun 20, 2019 in Power BI by Anitha
740 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,769 views
0 votes
1 answer

Forecast in Power BI

Hi, You can show a forecast for a ...READ MORE

Jun 13, 2019 in Power BI by anonymous
• 33,050 points
892 views
0 votes
1 answer

How to Filter a Query?

Hi, You can do the same in Power ...READ MORE

Jun 14, 2019 in Power BI by Avantika
• 1,520 points
840 views
0 votes
1 answer

Conditional formatting - Power BI

Hi Chandan, First, create a bar chart as ...READ MORE

Jun 13, 2019 in Power BI by anonymous
• 33,050 points
834 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,796 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,561 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,050 points
1,897 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,610 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,226 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,346 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,050 points
1,753 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,298 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,610 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
825 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,056 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
788 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
972 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,752 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 882 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,072 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,122 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
720 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
711 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
673 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
871 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,446 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,398 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,123 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
752 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,325 views