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
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
Best practices
1
vote
0
replies
27
views
Power BI slicer based on value in one columns and condition that this value is not available in related table
I have two related tables:
SD with columns: No, Date, etc.
Orders with columns: SDNo_, Date, etc.
Both are related with this No - SDNo as one SD to many Orders.
There some No, which are present in ...
Advice
0
votes
1
replies
54
views
How can I truncate the 15 lkh data set which is unfiltered to filter then upload on MySQL
I want that the data will arrange in a proper manner firstly the data have clear and remove duplicate and missing values then I write a my code in pandas to upload and process the same thing again ...
-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
Advice
0
votes
0
replies
37
views
How to do same layout align in power bi service for paginated report
My paginated report is displaying well align on web layout view .
But if I switch to print layout view , the page display is misalign so how can I have same align for both layout view .
I am using ...
- 4,588
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 ...
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
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
2
votes
2
answers
103
views
Rank (TopN) within Group
I have a table of data, and I want to sort by STATE, and then for each STATE, return the TopN (say Top 3 for example) COMPANY per state.
Using the generic visual filter for Top 3 Company, by Value, ...
- 23.5k
0
votes
0
answers
52
views
Measure shows total but isn't working on granular level in table
I need to calculate project budget in my table visual which should displays its total budget completely irrespective of any Period Year filter applied by the user. Below measure is working fine for ...
- 57
0
votes
0
answers
30
views
Writing a calculation group designed to make a slicer inactive
I have a slicer on PeriodSlicer[Period] for All Time, Full Year, Year to Date and Selected Dates.
Selected Dates should apply whatever dates are selected in the Calendar slicer, while the others ...
- 264
0
votes
0
answers
44
views
How do I create a dynamic title with a multi-select slicer to display when single, multi, and all selected?
I am attempting to create a dynamic title that will return the category when 1 item is selected, return multiple options separated by a comma when they're selected, and return "ALL" when ...
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
55
views
How to make a TEXT SLICER return the exact match instead of a search?
Originally TEXT SLICER is executing a SEARCH function so if user provides the first name and the column contains email addresses it will show all the email addresses with this first name. I am looking ...
-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
0
votes
1
answer
95
views
Power BI reports on images stored in private Azure storage account
I have a requirement of displaying images on Power BI report. These images are currently stored on Azure Storage v2 and the storage account is only accessible via private link/endpoint (public network ...
- 417
0
votes
1
answer
26
views
How to make a dependent slicer auto-reset when the current selection becomes invalid
I have two slicers:
Year from Calendar[Year] (values: 2023, 2024, 2025)
PlanType with two items: Planned and Actual spent
Data:
I have Actuals for 2023–2024, but no Actuals for 2025 (only Planned).
...
- 65
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
48
views
Calculating running total according to multiply groups in Power BI
I need to calculate the total number of piglets born per year and quarter, grouped by cycle. The cycle can range from 1 to 9. So I would like to see this: enter image description here There are some ...
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
vote
0
answers
62
views
Error occured while running DAX in Power BI which is connected to SSAS using live connect mode
I have connected my SSAS with MS Excel and all the dax which i am running is working fine .
Image of DAX result in MS Excel
But when i am connecting the SSAS with Power BI it is not running as ...
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
1
vote
1
answer
48
views
Filter date using bookmarks PowerBI
I would like to change the date daily by clicking on the arrow.
Selected date should be changed daily by clicking on the arrows. Is this even possible ? many thanks in advance.
I need something more ...
- 3,031
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