Most viewed questions in Power BI

0 votes
1 answer

How do I use Power BI Desktop with version control?

I would add a "Parameters" Query (a ...READ MORE

Dec 18, 2020 in Power BI by Gitika
• 65,730 points
1,021 views
0 votes
1 answer

Solving an error in my report query.

This situation typically happens when you have ...READ MORE

Nov 20, 2020 in Power BI by Gitika
• 65,730 points
1,018 views
0 votes
1 answer

How do Report server e-mail deliver reports?

Report server e-mail delivery can deliver reports ...READ MORE

Oct 15, 2018 in Power BI by Hannah
• 18,520 points
1,017 views
0 votes
1 answer

How to integrate python with power BI?

Python is often used for data visualization ...READ MORE

Nov 11, 2020 in Power BI by Gitika
• 65,730 points
1,016 views
0 votes
1 answer

How to enable left join with mysql group_concat csv merged instances of right side column values.

You can look for this:   let ...READ MORE

Nov 12, 2020 in Power BI by Gitika
• 65,730 points
1,015 views
0 votes
1 answer

Spell check in PowerBI

Use this API service and create a ...READ MORE

Mar 2, 2022 in Power BI by gaurav
• 23,580 points
1,014 views
+2 votes
2 answers

Counting the text values

To get the count of only yes, ...READ MORE

Aug 29, 2019 in Power BI by anonymous
• 33,050 points
1,013 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
1,012 views
0 votes
1 answer

How do I get my DAX measure to calculate grouped values?

Try this: Total Usage:= SUMX( VALUES(MyTable[SensorID]), [Usage]) An alternative ...READ MORE

Oct 8, 2020 in Power BI by Gitika
• 65,730 points
1,009 views
0 votes
1 answer

How can I join tables using only DAX?

You can see this below example: FILTER('InternetSales_USD' ...READ MORE

Oct 1, 2020 in Power BI by Gitika
• 65,730 points
1,004 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
1,002 views
0 votes
1 answer

Many to many relationship in BI

This is an error in the documentation.  As ...READ MORE

Nov 28, 2018 in Power BI by Upasana
• 8,620 points
1,000 views
0 votes
1 answer

How to show a color bar even when no value is present or value is 0?

To display a color bar even when ...READ MORE

Nov 28, 2024 in Power BI by anonymous
• 1,420 points
994 views
0 votes
1 answer

How to customize colors in columns in a bar chart?

There are two ways: Go to format tab -> ...READ MORE

Oct 31, 2019 in Power BI by anonymous
• 33,050 points
993 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
990 views
0 votes
1 answer

How to get a regression summary in scikit-learn like R does?

In sklearn, there is no summary report ...READ MORE

Feb 27, 2022 in Power BI by CoolCoder
• 4,420 points
989 views
0 votes
1 answer

what is power BI report server

Power BI Report Server is an on-premises ...READ MORE

Oct 15, 2018 in Power BI by Hannah
• 18,520 points
988 views
0 votes
1 answer

Multi region EC2 & RDS replication from Region A to various other regions

Because of its low latency, RDS is ...READ MORE

Mar 2, 2022 in Power BI by gaurav
• 23,580 points
984 views
0 votes
1 answer

Where is Power BI being used

Power BI is a business analytics service ...READ MORE

Oct 8, 2018 in Power BI by Kalgi
• 52,340 points
981 views
0 votes
1 answer

Categorised data in Power BI

Use a helper table to store these ...READ MORE

Feb 8, 2022 in Power BI by CoolCoder
• 4,420 points
978 views
0 votes
1 answer

Replace field values if matched

Create a custom column in Power Query ...READ MORE

Oct 31, 2019 in Power BI by anonymous
• 3,450 points
974 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, 2019 in Power BI by Sindhu
971 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
968 views
0 votes
1 answer

How to analyze the data in Power BI using Excel?

Once you've enabled editing and content, Excel ...READ MORE

Oct 27, 2020 in Power BI by Gitika
• 65,730 points
967 views
0 votes
1 answer

How to connect to data with PowerBI desktop?

With Power BI Desktop, you can connect ...READ MORE

Oct 27, 2020 in Power BI by Rajiv
• 8,870 points
965 views
0 votes
1 answer

How can I manage and resolve ambiguous relationships in Power BI data models?

Managing and resolving ambiguity relationships in Power ...READ MORE

Dec 30, 2024 in Power BI by Vani
• 3,580 points

edited Mar 6 962 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
957 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
956 views
+1 vote
2 answers

Microsoft Power BI exam (PL 300) voucher - retake included ?

When purchasing a Power BI (PL-300) exam ...READ MORE

Oct 25, 2024 in Power BI by pooja
• 24,450 points
955 views
0 votes
1 answer

Power BI Reporting Server - Portal Administrator Functionality

I think you need to link it ...READ MORE

Sep 25, 2018 in Power BI by Kalgi
• 52,340 points
949 views
0 votes
1 answer

Convert an expression from SQL to Power BI

Use the following expression: MyTemperatureTable = FILTER ( Device1234, ...READ MORE

Oct 22, 2018 in Power BI by Hannah
• 18,520 points
947 views
0 votes
1 answer

What options do I have for viewing and working with data on premises

There are three ways to achieve the ...READ MORE

Oct 15, 2018 in Power BI by Hannah
• 18,520 points
945 views
0 votes
1 answer

Power Query: Adding a Special Case

Try adding a Group By with Minimum ...READ MORE

Dec 27, 2018 in Power BI by Upasana
• 8,620 points
939 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
935 views
+1 vote
1 answer

Group by in PowerBi

Hi, One way is to create a ...READ MORE

Aug 12, 2019 in Power BI by anonymous
• 33,050 points
918 views
0 votes
1 answer

Why is conditional formatting not applying to all rows/columns in a Power BI table or matrix visual?

The most probable reasons for conditional formatting ...READ MORE

Dec 30, 2024 in Power BI by Vani
• 3,580 points

edited Mar 6 914 views
0 votes
1 answer

Do we have any auto email functionality in power BI?

You can embed an email link with ...READ MORE

Oct 29, 2020 in Power BI by anonymous
• 65,730 points
914 views
0 votes
0 answers

how to connect appsflyer data to power bi

how to connect appsflyer data to power ...READ MORE

Dec 18, 2020 in Power BI by Edureka
• 160 points
912 views
+1 vote
2 answers

How to get MS Power BI Data Analyst Associate PL-300 Badge for my Email Signature?

The following instructions explain how to properly ...READ MORE

Oct 24, 2024 in Power BI by pooja
• 24,450 points
904 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
904 views
0 votes
1 answer

Power BI in use cases

Power is BI is used for gathering ...READ MORE

Sep 27, 2018 in Power BI by Kalgi
• 52,340 points
904 views
0 votes
1 answer

Looking for a way to to list all cloud services with their description

A jQuery selector like this should do ...READ MORE

Sep 21, 2018 in Power BI by Kalgi
• 52,340 points
894 views
0 votes
1 answer

Power bi Reports

Yess! You should look into app.powerbi.com. That’s ...READ MORE

Sep 27, 2018 in Power BI by Kalgi
• 52,340 points
893 views
0 votes
1 answer

Is it possible to restrict SQL query result visibility by column data using RLS?

RLS is on row level, you can ...READ MORE

Nov 12, 2020 in Power BI by Gitika
• 65,730 points
890 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, 2019 in Power BI by Cherukuri
• 33,050 points
889 views
0 votes
1 answer

Is government, academic and nonprofit pricing available for Power BI?

Yes, nonprofit pricing is available when purchasing ...READ MORE

Sep 26, 2018 in Power BI by Kalgi
• 52,340 points
888 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
885 views
0 votes
1 answer

Excel PowerPivot DAX Calculated Field

You should create a relationship between each ...READ MORE

Oct 5, 2020 in Power BI by Gitika
• 65,730 points
884 views
+1 vote
1 answer

Can a Power BI view included in a website component?

Yes a power bi view can be ...READ MORE

Sep 26, 2018 in Power BI by Kalgi
• 52,340 points
879 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
872 views