3,531 questions with no answers
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
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 ...
- 671k
0
votes
0
answers
48
views
PowerBI row level security integration
RLS in Power BI Causing Blank Data – Need Help Debugging
Issue Summary
Applying Row-Level Security (RLS) in Power BI causes all data to go blank when testing with "View As Role" in Power BI ...
- 671k
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
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 ...
- 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 ...
- 1
-1
votes
0
answers
19
views
Matrix PBI presentation with monthly YTD vs YTD-1
In PBI, I need to create a matrix that, based on the selected month:
Display the data for the current month and the data for previous months of the same year.
Display the data for the months of the ...
- 19
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
1
vote
0
answers
51
views
Counting objects based on selected Start and End Date DAX PowerBI
I am working on a PowerBI project. I'm creating a dashboard for analyzing leave days.
The issue is I can't count only colleagues are filed their timesheet for leave and let other colleagues who have ...
- 20.2k
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
113
views
Custom function for replace
In Power BI I import different Excel files with data from Sales Channels. In order to merge data from these files one has to have the same channel names for sales channels. So prior to merging I try ...
- 14.5k
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
...
- 14.5k
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
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
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
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 ...
- 123k
0
votes
0
answers
61
views
Power BI DirectQuery to Redshift: ODBC error with pg_catalog.date_add(...) does not exist
I'm using Power BI Desktop with Amazon Redshift in DirectQuery mode. Data loads initially (sometimes at least / sometimes it has errors), but when I scroll down in a visual (e.g., table), I eventually ...
- 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
29
views
How to prevent jumpback on user input in deneb vega gantt chart?
I am trying to create a Vega Gantt Chart using the template from David Bacci - Deneb-Showcase.
In my original dataset I am taking the data from sharepoint and importing it into deneb visual. I did ...
- 25
0
votes
0
answers
39
views
Set custom colors for legends in stacked column chart
I have a stacked column chart and I want custom color for each brand present in the data. The brands are added in the legends section. I could go and set color manually for each individual brand but ...
- 39
0
votes
0
answers
31
views
How to align multiple tables and create dynamic last 3 months columns when migrating from Tableau
I am trying to migrate a Tableau dashboard to Power BI, and I’m having difficulty building the tables in the desired format.
I currently have 3 separate tables:
Matrix table – showing Classroom, ...
- 29
0
votes
0
answers
27
views
Multiple images in a single cell in Power BI table
I'm making a Project Status report on Power BI and the requirement is to display multiple KPIs with images on a single cell on a table. Status should be as follows (Green = green circle, Amber = ...
- 2,866
0
votes
0
answers
30
views
Save daily report to historical data set using FillDown in Power BI
I receive an Excel file, usually daily, that is used to display the current situation, but I want to take a summary of that data and add it to an historical file to show the performance over time. The ...
- 81
0
votes
0
answers
151
views
Couldn't publish my PowerBI dashboard on workspace - Error ClientOptions.Retry
I'm trying to publish a power BI dashboard via desktop on a workspace where I already have the report and the semantic model of this dashboard, but somehow it returns me the following error:
"...
- 21
0
votes
0
answers
71
views
Query a Dataset in Power Automate Not Returning Expected Results
I am trying to run a query against a dataset from PowerBI Semantic Model in Power Automate to return a CSV file with the outputs.
Steps I have taken:
Created a Power BI Desktop file that connects to ...
