27 questions from the last 30 days
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, ...
Advice
1
vote
1
replies
65
views
Modeling Recoverable Hours and Overtime in dbt/Power BI
I’m working on a reporting model that tracks recoverable hours and overtime for staff under a specific contractual agreement. I’d appreciate any advice on how you would approach modeling and ...
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 ...
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
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
vote
1
answer
48
views
Creating a Basket Analysis that Customers who buy X also LATER bought Y
I am trying to make a visual in Power BI that shows me what people order second, if they order x product first. Very similar to a basket analysis but I don't want to know what was in the same cart as ...
0
votes
0
answers
65
views
Mysql create a view for Power bi
I would like to create a view in mysql who show the place of my order as text. This place is a json object (example {"sap_hold": 1, "in_licensing": 1}). I would like to add a ...
0
votes
0
answers
33
views
How to add labels to Power BI "Filled map"?
I have a requirement where I need to add labels to the "Filled map" in power BI. I have found various ways to add labels to "Bubble map" but, I want to add labels to the "...
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 ...
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
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
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 ...
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
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 ...