Most viewed questions in Power BI

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,102 views
0 votes
1 answer

How can I make my visual distinct count total match the row by row sum when applying filters in PowerBI?

The COUNTROWS function can be used to ...READ MORE

Jul 28, 2020 in Power BI by Gitika
• 65,910 points
6,998 views
+1 vote
1 answer

Have column with multiple values in powerBI, for use with a slicer in power bi

It can be achieved depending on the result you ...READ MORE

Oct 22, 2018 in Power BI by Hannah
• 18,570 points
6,995 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
6,933 views
0 votes
1 answer
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
6,741 views
0 votes
1 answer

How to add image in Power BI Report?

Follow the below steps: Create a column with ...READ MORE

Oct 31, 2019 in Power BI by Cherukuri
• 33,030 points
6,737 views
0 votes
1 answer

How can I use Power BI on my Ubuntu machine

Hey, @Jublleevdsl, Based on my research, currently, it ...READ MORE

Nov 23, 2020 in Power BI by Gitika
• 65,910 points
6,565 views
0 votes
1 answer

How to ignore a slicer for one measure, but apply it on another?

In order to ignore Slicer you need ...READ MORE

Oct 1, 2020 in Power BI by Gitika
• 65,910 points
6,400 views
0 votes
1 answer

Difference between Power Bi Desktop and Power BI Service

Power BI Desktop is a robust resource for data analysis and reporting. It performs all reports, modelling using ...READ MORE

Oct 29, 2019 in Power BI by ch
• 3,450 points
6,321 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,311 views
+2 votes
1 answer

How to export data to CSV from power bi embedded url ?

Hi Arathi, You can open Visuals from embedded ...READ MORE

Aug 23, 2019 in Power BI by anonymous
• 33,030 points
6,235 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,021 views
0 votes
1 answer

How to export Power Queries from One Workbook to Another with VBA?

Try solving it using the Workbook. Query ...READ MORE

Oct 22, 2018 in Power BI by Annie97
• 2,160 points
5,951 views
0 votes
1 answer

How to Convert measure to calculated column?

Hi, I have created a new measure using ...READ MORE

Jul 18, 2019 in Power BI by Avantika
• 1,520 points
5,877 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
5,707 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
5,659 views
0 votes
1 answer

How to make a table Hyperlink in Excel Power Pivot?

Hey, You can follow these steps to make a ...READ MORE

Feb 6, 2020 in Power BI by Gitika
• 65,910 points
5,657 views
0 votes
1 answer

How to get month name from month number in Power BI?

You can use: MonthName = FORMAT(DATE(1, [Num], 1), ...READ MORE

Sep 24, 2020 in Power BI by Alisha
5,615 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,030 points
5,605 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,582 views
+2 votes
2 answers

Power BI service throwing 403 error when using token to embed Power BI report

To add to @Kalgi's answer, Also make ...READ MORE

Oct 3, 2018 in Power BI by Nilesh
• 7,050 points
5,471 views
0 votes
1 answer

How to calculate average percentage in Power BI?

You can add one more measure to ...READ MORE

Feb 23, 2022 in Power BI by CoolCoder
• 4,400 points
5,448 views
0 votes
1 answer

DAX : Occurrences of "count"

Try this for creating a calculated column ...READ MORE

Nov 22, 2018 in Power BI by Upasana
• 8,620 points
5,257 views
0 votes
1 answer

By default, which level of filter behaves as same as a slicer in a report in Power BI desktop?

Hey, There are several types of filters in ...READ MORE

Jan 31, 2020 in Power BI by Rakesh
5,242 views
0 votes
1 answer

Call endpoint from Kubernetes Cron Job

CronJobs are a good choice. Here's a ...READ MORE

Sep 27, 2018 in Power BI by Kalgi
• 52,360 points
5,096 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,022 views
0 votes
1 answer

Row Level Security not applied through LOOKUPVALUE in Default filter [closed]

I see what you mean now. LOOKUPVALUE appears to ...READ MORE

Nov 8, 2018 in Power BI by Upasana
• 8,620 points
4,914 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,819 views
0 votes
1 answer

Power BI (DAX): Distinct Count Filtered by Condition

You can go with this: DistinctCountActiveMonths = CALCULATE( ...READ MORE

Nov 18, 2020 in Power BI by anonymous
• 65,910 points
4,752 views
0 votes
1 answer

Scraping Data from a website which uses Power BI - retrieving data from Power BI on a website

Putting the scroll part and the JSON ...READ MORE

Dec 22, 2020 in Power BI by Gitika
• 65,910 points
4,749 views
0 votes
1 answer

Passing a parameter to Power BI Embedded via embedded URL

Add the following to the end of ...READ MORE

Oct 23, 2018 in Power BI by Annie97
• 2,160 points
4,721 views
0 votes
1 answer

DAX Calculation the Max for a Group.

You can try this out:  Desired Output=CALCULATE(MAX([Check]), ...READ MORE

Sep 25, 2020 in Power BI by Gitika
• 65,910 points

edited Sep 25, 2020 by Gitika 4,638 views
+1 vote
1 answer

getting client-credentials access token to authorize Power BI

Try and make sure that the app ...READ MORE

Oct 17, 2018 in Power BI by Annie97
• 2,160 points
4,614 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
4,610 views
0 votes
1 answer

Power BI not able to connect to Azure SQL with private end point

You'll need to install an on-prem gateway ...READ MORE

Feb 17, 2022 in Power BI by CoolCoder
• 4,400 points
4,588 views
0 votes
1 answer

Embedding a dashboard using Java in Power BI

Make sure to use the correct embedURL, ...READ MORE

Nov 30, 2018 in Power BI by Shubham
• 13,490 points
4,569 views
0 votes
2 answers

Can I get rid of the grey border on the report visuals with power bi embedded?

It's just a simple css code to ...READ MORE

Apr 19, 2020 in Power BI by Prateek Mehta
4,562 views
0 votes
1 answer

How to measure in DAX to calculate YTD for chosen month only for Power BI?

If you use the date column from FactTable, ...READ MORE

Dec 22, 2020 in Power BI by Gitika
• 65,910 points
4,494 views
0 votes
1 answer

How to create Pivot Tables in Power BI?

Hey, First of all, there is no "Pivot ...READ MORE

Feb 6, 2020 in Power BI by Gitika
• 65,910 points
4,475 views
0 votes
1 answer

What is query editor in Power BI?

Hi, Power BI Desktop also comes with Power ...READ MORE

Feb 4, 2020 in Power BI by Rishikesh
4,475 views
0 votes
1 answer

How do you create a link visual in Power BI?

You can easily create a link between ...READ MORE

Mar 9, 2019 in Power BI by Avantika
• 1,520 points

edited Mar 9, 2019 by Avantika 4,425 views
0 votes
1 answer

Using RELATED function in DAX with USERELATIONSHIP

Here's an example using the AdventureWorksDW data ...READ MORE

Nov 18, 2020 in Power BI by anonymous
• 65,910 points
4,419 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,030 points
4,265 views
0 votes
1 answer

How can I search for multiple strings?

A simple solution is this: List.ContainsAny(Text.SplitAny("This is a test ...READ MORE

Oct 24, 2018 in Power BI by Upasana
• 160 points
4,235 views
0 votes
1 answer

Time Series Chart in Power BI

Your Date format should be handled by ...READ MORE

Nov 26, 2018 in Power BI by Upasana
• 8,620 points
4,216 views
0 votes
3 answers

How do I get token using javascript API while trying to embed graphs using Power BI

Use ADAL.js that will give you an ...READ MORE

Jun 22, 2019 in Power BI by anonymous
4,188 views
+1 vote
2 answers

403 error thrown by power bi report server when trying to get list of data sets

Hey @saranya, Try removing the header and ...READ MORE

Oct 29, 2018 in Power BI by Kalgi
• 52,360 points
4,155 views
0 votes
2 answers

DataFormat.Error Power BI Desktop

The invalid escape sequence is caused by ...READ MORE

Sep 25, 2018 in Power BI by Nilesh
• 7,050 points
4,144 views