Trending questions in Power BI

0 votes
0 answers

How to connect DimDate table to fact and dimensional tables?

Hi, I have fact table,Dim project , Dim ...READ MORE

Nov 20, 2021 in Power BI by asheni
• 120 points
384 views
0 votes
1 answer

How to convert a Integer to Text value in Power BI?

Make sure you have the correct format ...READ MORE

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

What is the difference between DAX and Power Query?

DAX stands for Data Analysis Expressions. DAX ...READ MORE

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

What do “Enable Load” and “Include In Report Refresh” mean/do?

"Include In Report Refresh" means query is ...READ MORE

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

Using Multiple filters in DAX

CALCULATE is defined as CALCULATE(<expression>,<filter1>,<filter2>…) This means that you can ...READ MORE

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

How do you Hide and Unhide a Specific Report in Power BI?

In the menu bar, choose the Selection ...READ MORE

Oct 20, 2020 in Power BI by Gitika
• 65,770 points
10,724 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,770 points
7,187 views
0 votes
1 answer

How to demote Headers in Power BI query editor?

Hi, There are the steps which you can ...READ MORE

Feb 3, 2020 in Power BI by Jitesh
19,263 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,770 points
5,268 views
0 votes
1 answer
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,770 points
4,902 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,770 points
5,391 views
0 votes
1 answer

How to convert eight digit yyyymmdd to date using DAX in Power BI ?

You can go through this: column = IFERROR( ...READ MORE

Dec 8, 2020 in Power BI by Gitika
• 65,770 points
4,256 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,770 points
4,965 views
0 votes
1 answer

How to create action button in Power BI?

Hi Raghav, Follow the below steps: 1. Click on ...READ MORE

Jun 20, 2019 in Power BI by Cherukuri
• 33,030 points
27,227 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,770 points
6,924 views
0 votes
1 answer

How to parse a .json column in Power BI?

Use Json.Document function like this let ...READ MORE

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

Distinct count filtered by condition using Power BI Dax

Try this, it should work: DistinctCountActiveMonths = CALCULATE( ...READ MORE

Oct 5, 2018 in Power BI by Kalgi
• 52,350 points
37,703 views
0 votes
1 answer

how to connect firebase data into power bi

Hi, @There, Click “Get Data->Blank Query” to add ...READ MORE

Dec 18, 2020 in Power BI by Gitika
• 65,770 points
2,665 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
6,316 views
+2 votes
1 answer

how to split country & city in Dax power bi

After loading the dataset, you can split ...READ MORE

Nov 25, 2020 in Power BI by Gitika
• 65,770 points
3,511 views
0 votes
1 answer

Couldn't retrieve the data for this visual.

The error you mentioned here is usually ...READ MORE

Nov 2, 2020 in Power BI by Gitika
• 65,770 points
4,319 views
0 votes
1 answer

how to create snapshots in power BI?

Snapshots enable faster loading of specific properties. Follow ...READ MORE

Oct 29, 2019 in Power BI by Cherukuri
• 33,030 points
20,282 views
0 votes
1 answer

How to use Dynamic DAX Number Format in power BI?

You can give them the same display ...READ MORE

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

Can't get client-credentials access token to authorize Power BI

With the assistance of some Microsoft folks ...READ MORE

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

Slicer with conditions - if value selected,select related values

I assume that both tables are unrelated ...READ MORE

Nov 12, 2020 in Power BI by Gitika
• 65,770 points
3,474 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,770 points

edited Sep 25, 2020 by Gitika 5,266 views
0 votes
1 answer

In DAX, how do I RETURN the sum of a calculated column from a DAX Table Variable (created via ADDCOLUMN)?

You can access column variables of previously ...READ MORE

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

I have a web API with basic authorisation and username and password. How do i connect to it in Power BI?

Hey, @There, I found your query is quite ...READ MORE

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

How to restart running total column with Power BI Desktop DAX?

This is not only a running total ...READ MORE

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

How to create summary table based on selected filters/slicers?

Here are the steps you can follow: 1. ...READ MORE

Nov 12, 2020 in Power BI by anonymous
• 65,770 points
3,010 views
0 votes
1 answer

Can we delete datasets in pro from works space in Power Bi

Hi, @Naveen, Please go through the given below ...READ MORE

Nov 26, 2020 in Power BI by Gitika
• 65,770 points
2,323 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,770 points
7,502 views
0 votes
1 answer

Is it possible to use R Plotly library in R Script Visual of Power BI?

For newer versions of PowerBI, it's also ...READ MORE

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

Failed to load files, showing please wait while we establish a connection to <filename>'.

 One thing you can do is that ...READ MORE

Oct 22, 2020 in Power BI by anonymous
• 65,770 points
3,537 views
0 votes
1 answer

Direct Query Cannot Load Model. Login Failed for user. The exception was by raised by the IDbConnect

The current power bi pbix file connection ...READ MORE

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

How to connect google sheet with power bi?

If you're not limited to R Studio, ...READ MORE

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

Cannot install Microsoft Power Bi Postgre SQL connector

There seems to be some problem with ...READ MORE

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

Task's Exception(s) were not observed.

I suggest you go the the "Files" - ...READ MORE

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

How to calculate PowerBI / DAX - Row wise division by measure?

As for your question, I think you're ...READ MORE

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

how to sync firebase data into power bi?

Hi, @There, As far as I know, it ...READ MORE

Dec 18, 2020 in Power BI by Gitika
• 65,770 points
853 views
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,770 points
788 views
0 votes
1 answer

Cumulative distinct count filtered by last value - DAX

MyFilteredCumulativeMeasure = COUNTROWS( FILTER( ...READ MORE

Nov 18, 2020 in Power BI by anonymous
• 65,770 points
2,092 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
755 views
0 votes
1 answer

Error : Function 'GROUPBY' scalar expressions have to be Aggregation functions over CurrentGroup().

The error says you need to use ...READ MORE

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

What is the difference Between SUM() and SUMX()

Sum function (Sum()) takes the data columns ...READ MORE

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

Several errors occurred during data refresh.

"Connexion successful" mean "the network connection is ...READ MORE

Nov 16, 2020 in Power BI by Gitika
• 65,770 points
2,005 views
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,845 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
839 views