Questions tagged [powerbi]
Power BI is a free, self-service analytics tool available individually or integrated with Microsoft Excel, Office 365 and many major databases and analytics tools.
powerbi
20,448
questions
0
votes
1
answer
22
views
How to count results after advanced filtering
enter image description here
When i selected the advanced filtering, this statistic has not changed and still shows the total number.
Filtered Records = CALCULATE(COUNTROWS(TableItems))
It updates ...
0
votes
0
answers
13
views
Change PowerBI Data Source Server without Refreshing Report in PBI Desktop
I have a large number of PowerBI reports where the Source Server and DB is "ServerA.Database1". I have setup data replication so that the tables necessary for reporting are now available in &...
0
votes
0
answers
10
views
On Histogram, show all months of the year but hide columns that a beyond the selected date
I'm trying to hide these columns.
I have edited the interaction of the chart so that a slicer with the date does not effect it to show all months for the year.
I can do it with calendar_date<=max(...
0
votes
0
answers
4
views
How to Integrate AWS-Based custom Data Platform with Power BI While maintaining RBAC and handling large Data Sizes?
We have an internally built and maintained Data Platform. Here is a brief summary of the problem:
The platform uses AWS services. We want users to create Power BI dashboards with data sourced from ...
0
votes
0
answers
8
views
Using Power BI Desktop I've created a table below, now I want to recreate this table based on the max value of total purchase per country
the last column of the table was derived from the calculation of the Order Details table.
the relations of the tables have been shown below as well. Since two columns came from two different tables (...
2
votes
1
answer
24
views
Show previous period and current period in the same line chart
I want to show the current period and previous period in the same line chart. The problem is that I need to be able to use slicers. For example
I am plotting an entire year, but if I want to select ...
0
votes
0
answers
7
views
PowerBI Data Export: Large Matrix Table
BLUF: With the current May 2024 PowerBI Desktop, I can look at a Matrix Visual in Reports, and export as CSV the complete expanded table. But PBI chops the table at 10K rows, and the table when ...
0
votes
0
answers
5
views
Power BI online data no refreshed when using Power BI online
Report developed in power bi desktop and published to Power Bi online where my data source is Sharepoint online list. I am not able to refresh data as we use to do in Power Bi desktop (like we able ...
0
votes
0
answers
8
views
Using CONTAINSSTRING to create relationships between two data tables
I'm connecting to a SharePoint list with choice columns. One of the list columns is a choice column titled "Assigned to" with the option to select one or more city from a list. In PBI, that ...
0
votes
1
answer
13
views
Blank Values in Date table for a formula
I am trying to find the week ending for in the date table, however I realise the formula is giving me blanks on some of the months.
Week Ending on = CALCULATE(MIN([Date]),FILTER('Date',WEEKDAY([Date],...
0
votes
0
answers
11
views
Power BI DAX Calculate Moving Average While Ignoring Weekdays From Date Hierarchy
I am trying to create a moving average measure that gives me the moving average per month. My data has weekday as lowest level; however for this specific measure (and visual) I do not want the ...
1
vote
1
answer
18
views
Not to show/hide values in second slicer based on first Slicer
How can we hide values which are less than in second slicer based on selected value in first slicer
Ex: If user select value 6 in first slicer then in second slicer values need to apper only >=6 (...
0
votes
0
answers
15
views
Dynamic columns to summarize in Power BI
Below is the sample data i have:
I have two date parameters which the user will select dynamically. Let say they select 2024-07-01 and 2024-10-30. i would need the values summarized for the months ...
1
vote
1
answer
24
views
Power BI calculate tiered commission, commission threshold changes over time
I have sales records, if the sales involves Party B, Party A has to split revenue with Party B for all sales >$10000. This split is set by the threshold below, and the boss is free to update the ...
0
votes
0
answers
34
views
can all my dimension tables hav the same primary key?
I have the below tables:
info: (symbol/ country/ city/ address/ market/ industry...)
balance sheet: (symbol/date/ total debt/ total assets...)
income statement: (symbol/date/ net income...)
statistics:...