20,652 questions
Advice
0
votes
0
replies
15
views
Power BI stacked column chart values change incorrectly when multiple selections are made in the slicer
I have a stacked column chart in Power BI showing hours worked per staff on respective tasks.
Table: Tasks
Fields:
X-axis: Tasks[EmpName]
Values: Tasks[totalhrs] / 7
Legend: Tasks[Taskname]
...
- 5
0
votes
1
answer
24
views
Issue with Python Visuals in Power BI Embedded (.NET Core)
I am facing an issue with Power BI Embedded reports in a .NET Core application. The report contains Python visuals, which work correctly in Power BI Desktop and Service, but they do not render when ...
- 1
1
vote
1
answer
67
views
Remove Cast on int fields on directQuery to 2 billion row fact when computing averages
Using Power BI directQuery to databricks SQL warehouse, I see the queries getting generated to compute an average have
SELECT
SUM(CAST(int_field AS DOUBLE)), COUNT(int_field)
FROM
fact
...
- 11
0
votes
0
answers
20
views
How to make quick measure of each data reference back to the same category of the original data?
pbix file:
https://x0.at/dnPB.pbix
So I have a line and clustered column chart. On the line y-axis, by default my original data (Median Gross Monthly Salary under the table Median Salary of FTP) will ...
- 1
0
votes
1
answer
46
views
How to calculate overlapping 4-month rolling averages with a month slicer?
I have an attendance summary table with the following columns:
EmployeeID
Date
WorkHours
I need to create a visual (or table widget) in Power BI that shows employees who worked more than 48 hours ...
-3
votes
0
answers
35
views
Power BI - Dynamics - Issues Filtering Query in GetData
Im having an issue where I'm pulling data from Dataverse. The query itself always returns as too complex. I cannot transform the data at the GetData stage because its too complex and I cannot preview. ...
- 1
0
votes
1
answer
34
views
Calculating working days considering different weekends - Power BI DAX
I want to calculate the "working days" between 2 dates in Power BI. Middle east and north africa countries have different weekends (for example Egypt and Saudi Arabia Fri,Sat, the rest Sat, ...
- 1
0
votes
0
answers
25
views
How to define visual-level formatting (color, size, etc.) in Power BI PBIP visual.json vs baseTheme?
I’m currently working on a project where I take an image of a Power BI dashboard and automatically generate a Power BI PBIP project that replicates the exact layout and visual design of the dashboard ...
0
votes
0
answers
39
views
Query loading a lot of data from a small file [closed]
I have a power bi report with four connections to four excel files.
One of the files is around 1500 rows and 800 KB of memory.
The query i am interested in appends three queries, each one of those ...
- 9
Best practices
0
votes
0
replies
51
views
Power BI data table
I am currently importing about 560k lines of data from 12 system reports into Power BI and then appending into a central table to start building from it, however the append is taking nearly an hour to ...
- 23
0
votes
0
answers
38
views
How to Implement Row-Level Security (RLS) in Power BI with DirectQuery Dataset Embedded via .NET Core
I’m working on embedding a Power BI report that uses a DirectQuery dataset, and I want to implement Row-Level Security (RLS) through my .NET Core backend.
Setup Details:
Report Type: Power BI PBIX ...
- 1
-1
votes
2
answers
189
views
How to automaticaly switch between dashboards?
I would like to switch between dashboard in Power BI.
I prefer power bi desktop app, in power automate is it possible create an automatic workflow?
If power automate doesn't work there is another ...
- 85
1
vote
0
answers
59
views
An error happened while reading data from the provider: 'Object reference not set to an instance of an object.'
I am able to connect to OracleDB from Power BI desktop. after publishing the dashboard and having the on premises gateway setup, it was working fine. I installed on premises gateway on another system ...
0
votes
1
answer
99
views
Unable to embed PowerBI report
I am trying to embed a PowerBI report into a webpage, using NodeJS and I ended up getting this:
{message: 'LoadReportFailed', detailedMessage: 'Fail to initialize - Could not resolve cluster', ...
- 964
0
votes
0
answers
34
views
How to embed reports with row-level security on an external website?
I'm making a report that contains RLS rules based on the function USERPRINCIPALNAME(). Basically, I've created a measure that will:
get logged in user's email
do a VALUELOOKUP and find their user_id
...
0
votes
0
answers
44
views
Calculated Column as Bar Chart item - Power BI DAX
I'm pretty new to DAX and so can't quite figure this out. I'm using a pre-generated Sales data model to create a Bar chart which shows the Average Order Quantity for Customers and grouped by each ...
- 161
0
votes
1
answer
39
views
How to show latest date first (descending order) in Power BI Matrix column headers?
I am building a Power BI dashboard where my Matrix visual has employees in rows and dates in the column headers.
The date field I am using is:
Hours_Provided_by_Manager_ScriptOutput_AMOps[...
- 11
1
vote
0
answers
32
views
Snapshot of Power BI table using dataflow
I have a table in power bi which has calculated column based on azure table and Dataverse. (Dataverse is used for write back feature using power automate as few of the column value get changed).
Table ...
- 68
0
votes
1
answer
41
views
Power BI Filter rows to remove nulls based on a condition
I have a combined table powering a PowerBI report that has an issue with almost duplicate rows.
I have 2 records for certain SubIDNo entries, but for one of those I don't have a DateChecked. They all ...
- 117
2
votes
1
answer
96
views
How to allow a visual row to access all rows of a particular column in the visual?
I have a visual using columns from the Timesheets and Users tables, using the relationship on [_userID] (Users-to-Timesheets, one-to-many, single). Each row of the visual is uniquely defined by ...
- 264
1
vote
0
answers
172
views
QueryUserError when published
I built a Power BI report by importing two semantic models from other reports.
In those original reports, I had created tables with calculated results since it would be unfeasible to rebuild all ...
- 1,954
0
votes
1
answer
33
views
Calculating the right ratio in a matrix with subrows in Power BI and DAX
I'm dealing with the following situation in Power BI.
I have a matrix where:
Rows contain client names (sales[cardname])
Subrows contain the products related to each client (sales[itemname])
I'm ...
- 1
0
votes
0
answers
44
views
My vega code is compiling fine but not creating a visual in PowerBI. How do I resolve this?
I'm very new to Vega, mainly because I need a flow map in PowerBI under several constraints that make other methods unfeasible, and thus I've been attempting to create a custom visual with Vega. As it ...
0
votes
0
answers
44
views
Measure to average all rows in Power Bi matrix
I want to add a meaure that averages the STORE COUNT column for all rows in attached Power BI matrix.
The STORE COUNT column is a Count summarization in the Values section of the matrix.
I would like ...
0
votes
0
answers
38
views
Power BI - MIN/MAX Issue
I have the following matrix in Power BI with the measures "First Period", "Second Period", "<> Change", and "% Change" (the DAX code for the First Period ...
- 21