Trending questions in Power BI

0 votes
1 answer

PowerPivot DAX - Dynamic Ranking Per Group (Min Per Group)

Firstly create a basic measure [Amount] to sum the ...READ MORE

Nov 18, 2020 in Power BI by Gitika
 • 65,770 points • 1,973 views
0 votes
1 answer

user select on filter to show the bars

Hi, @There, There are multiple steps which you ...READ MORE

Dec 10, 2020 in Power BI by Gitika
 • 65,770 points • 924 views
0 votes
1 answer

DAX Previous Month to date total is giving entire previous month's entire total

You can go through this: PMYTD = ...READ MORE

Oct 8, 2020 in Power BI by Gitika
 • 65,770 points • 3,619 views
0 votes
1 answer

DAX Calculate function with and without FILTER

You could make [Measure12] return the same results as ...READ MORE

Sep 24, 2020 in Power BI by Gitika
 • 65,770 points • 4,190 views
0 votes
1 answer

How to use No QUARTER() in DAX in power BI?

One should use =ROUNDUP(MONTH([Date])/3, 0) to get quarte ...READ MORE

Dec 8, 2020 in Power BI by Gitika
 • 65,770 points • 911 views
0 votes
1 answer

Is it possible to use multiple dataset for one report?

Yes, of course, you can load a few ...READ MORE

Oct 29, 2020 in Power BI by Gitika
 • 65,770 points • 2,574 views
0 votes
1 answer

Error Error on Data load when open report in server "An error has occurred"

The problem you can solve by edit this ...READ MORE

Nov 16, 2020 in Power BI by Gitika
 • 65,770 points • 1,723 views
0 votes
1 answer

Add leading 0 (zero) to month number in power BI

You can use the FORMAT function for this: Expiry_MonthYear_Sorter = ...READ MORE

Oct 8, 2020 in Power BI by Gitika
 • 65,770 points • 3,356 views
0 votes
1 answer

Direct Query Report gateway connection error

There can be many reasons for this ...READ MORE

Nov 19, 2020 in Power BI by Gitika
 • 65,770 points • 1,482 views
0 votes
1 answer

How to connect Github with power BI?

There are few steps which we need ...READ MORE

Nov 19, 2020 in Power BI by Gitika
 • 65,770 points • 1,521 views
0 votes
1 answer

Power BI Visualization

Power BI supports R integration for data ...READ MORE

Dec 7, 2020 in Power BI by Gitika
 • 65,770 points • 692 views
0 votes
1 answer

I need to give a filter where one filter is selected, the logged in user's data from the application has to be shown ​, if another filter is selected we need to show all the data

Hey, @Satish, Create or edit a filter action Do ...READ MORE

Dec 1, 2020 in Power BI by Gitika
 • 65,770 points • 897 views
0 votes
1 answer

Error refreshing dataset with direct query using on-premise gateway connection

What is your data source type? Could ...READ MORE

Nov 19, 2020 in Power BI by anonymous
 • 65,770 points • 1,404 views
0 votes
1 answer

Unable to Connect to import or direct query reports

Check your cached data sources. Once in ...READ MORE

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

Error: We couldn't find any data in your Excel workbook

To import from Excel into the Power ...READ MORE

Oct 22, 2020 in Power BI by Gitika
 • 65,770 points • 2,383 views
0 votes
1 answer

Display data points below chart when bar is selected.

You can use a matrix visual just ...READ MORE

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

DAX EARLIER() function in Power Query

Solutions in the code below. Notice that ...READ MORE

Oct 1, 2020 in Power BI by Gitika
 • 65,770 points • 3,268 views
0 votes
1 answer

How to connect webpage data by using Power BI Desktop?

Web connections are only established using basic ...READ MORE

Nov 18, 2020 in Power BI by Gitika
 • 65,770 points • 1,155 views
0 votes
1 answer

How can You Change the Value Measure to Show Multiple Measures Dynamically?

You can dynamically change and switch functions ...READ MORE

Oct 20, 2020 in Power BI by Gitika
 • 65,770 points • 2,391 views
0 votes
1 answer

How to connect a dataset to a SQL Server database?

In Power BI Desktop, you connected directly ...READ MORE

Nov 18, 2020 in Power BI by Gitika
 • 65,770 points • 1,071 views
0 votes
1 answer

Custom Slicer with two calendar date pickers and custom periods?

This exact look and feel are not ...READ MORE

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

How to connect to data in Power BI Desktop

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

Nov 18, 2020 in Power BI by Gitika
 • 65,770 points • 1,038 views
0 votes
1 answer

R scripts for Importing Data in powerBI?

There may be times when you don’t ...READ MORE

Nov 11, 2020 in Power BI by Gitika
 • 65,770 points • 1,295 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,770 points • 846 views
0 votes
0 answers

Error: The name provided is not properly formed account name.

Today I try to create a new ...READ MORE

Nov 12, 2020 in Power BI by Roshni
 • 10,480 points • 1,149 views
0 votes
1 answer

Error occurred. Unable to load drag and drop problem.

You can solve this by logging in to ...READ MORE

Nov 16, 2020 in Power BI by Gitika
 • 65,770 points • 936 views
0 votes
1 answer

Queries Metadata Loading data into Model... Fail

In the DirectQuery mode, no data is ...READ MORE

Nov 16, 2020 in Power BI by Gitika
 • 65,770 points • 903 views
0 votes
1 answer

How to calculate average inventory in power bi?

Hi @There, Is there any index field in ...READ MORE

Sep 28, 2020 in Power BI by Gitika
 • 65,770 points • 2,923 views
0 votes
1 answer

How to install and setup power BI?

Installation and Set up Listed below are a ...READ MORE

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

How to integrate R with PowerBI?

Including Python and R in Power BI ...READ MORE

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

How to import data model from Excel in PowerBI?

You may try to divide your data ...READ MORE

Oct 22, 2020 in Power BI by anonymous
 • 65,770 points • 1,789 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,770 points • 835 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,770 points • 867 views
0 votes
2 answers

Transform a heavy calculated measure (accumulated) into a column in Power BI

Hello, @Marinafr, If you are using Pro License ...READ MORE

Oct 23, 2020 in Power BI by Rajiv
 • 8,870 points • 1,612 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,770 points • 740 views
0 votes
1 answer

How to change import mode to direct mode of connection in powerBI

Create a new file connect in import ...READ MORE

Oct 29, 2020 in Power BI by anonymous
 • 65,770 points • 1,204 views
0 votes
1 answer

How to verify that R and R studio are installed on your system?

To verify that R and R studio ...READ MORE

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

How to convert date format in PowerBI?

Change the column data type in excel ...READ MORE

Oct 29, 2020 in Power BI by anonymous
 • 65,770 points • 1,174 views
0 votes
1 answer

How to create a Measure using Power BI DAX?

The following steps make your task simple ...READ MORE

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

How to trim space from Power BI?

Hey, Make sure your column type is set ...READ MORE

Feb 6, 2020 in Power BI by Gitika
 • 65,770 points • 12,553 views
0 votes
1 answer

How to find out what all datasets are currently running without manually seeing the each dataset refresh history in PowerBI

Go to ur workspace, click on dataset ...READ MORE

Oct 29, 2020 in Power BI by Gitika
 • 65,770 points • 1,068 views
+2 votes
1 answer

How to connect to mysql database from power Bi?

Hi, Follow these steps, to connect to MYSQL ...READ MORE

Mar 22, 2019 in Power BI by Cherukuri
 • 33,050 points • 26,309 views
0 votes
1 answer

Recursive logic in DAX

Hey,  The only option is to break down ...READ MORE

Sep 28, 2020 in Power BI by Gitika
 • 65,770 points • 2,357 views
0 votes
1 answer

How DAX Difference between naked SUM and sum wrapped in CALCULATE?

This is materially different than the question ...READ MORE

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

Count occurrences in DAX

You can use DAX functions to do ...READ MORE

Mar 9, 2019 in Power BI by Avantika
 • 1,520 points • 26,875 views
0 votes
1 answer

DAX. Problem with subtotals and grand totals

Create a new measure for the km ...READ MORE

Oct 5, 2020 in Power BI by Gitika
 • 65,770 points • 1,963 views
0 votes
1 answer

How to add a One drive Excel as a Data set in Power BI?

If the one Drive is from your ...READ MORE

Oct 29, 2020 in Power BI by anonymous
 • 65,770 points • 930 views
0 votes
1 answer

How to Toggle Between Two Option and Make it Interact with the rest of the Visualizations in a Report?

Toggling is an action that is achieved ...READ MORE

Oct 20, 2020 in Power BI by anonymous
 • 65,770 points • 1,220 views
0 votes
1 answer

DAX formula to concatenate three columns.

If the columns are already text, you ...READ MORE

Oct 1, 2020 in Power BI by Gitika
 • 65,770 points • 1,983 views
0 votes
1 answer

Import Excel data to power Bi service

There is a  way that is directly ...READ MORE

Oct 22, 2020 in Power BI by Gitika
 • 65,770 points • 1,071 views
Page:

Most popular tags

"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.