Questions tagged [powerbi-desktop]
Power BI Desktop is the desktop application for Power BI, a free, self-service analytics tool.
powerbi-desktop
4,464
questions
0
votes
0
answers
9
views
Selected Previous Amount in DAX
I have a rank table as below which is merged with my FactTable. Previous_Amount works find until I select 2 non consecutive FYandFWOnum number.
FYandFWOnum Rank
202448 1
202452 ...
0
votes
0
answers
8
views
Call Power Automate HTTP Request Trigger in Power BI for data source
In Power Automate I have a HTTP Request Trigger automation set up that generates some data and returns the JSON.
When this Power Automate flow is set to 'Anyone' for "Who Can Trigger The Flow&...
0
votes
0
answers
12
views
Row Totals not Populating in PowerBI chart
I am building a report on PowerBI Desktop.
I have a measure that is producing column totals but is not producing row totals.
Pipeline Target =
SWITCH (
TRUE (),
ISINSCOPE ( '...
0
votes
0
answers
7
views
PowerBI parameter not passing correctly to SQL query and returning results
I have a PowerBI dashboard that I'm building which needs to limit the data in the SQL query due to the quantity of data that exists in the tables/views of origin. Additionally, as the WHERE statement ...
2
votes
1
answer
25
views
Need help in filtering using measure in power bi
I have 2 measures in my power bi report which show cumulative trend based on two date columns namely created date and closed date. The 2 trend lines show total number of bugs created vs total number ...
0
votes
1
answer
30
views
Power BI Gantt Chart - Tasks with 3 hierarchy levels and monthly view
I'm using David's Bacci Gantt Chart via Deneb app from the pbix available here
My data is a direct export from MS Project with 3 levels of task hierarchy which I would like to include within the PBI ...
1
vote
1
answer
15
views
Y/X-Axis Zoom Slider in Deneb Vega Lite?
In Deneb vega-lite I am looking for the ability to zoom slide on the y-axis and x-axis as you would a native Power BI line chart.
Here is the template i used.
Ideally, would like these sliders to sit ...
0
votes
0
answers
17
views
Power BI Retail Sales LY Same Day of Week Same Week Number
I have an interesting dilemma. In Power BI I would like to make comparisons to the same day of week same week number last year. In Power BI I have not found a way to create this. There is the function ...
-1
votes
0
answers
40
views
How to model project and tasks (1:M) to allow user to drill down? [closed]
I have following tables:
Customer: custid, name
Location: locid, name
Project: projid, custid, locid, name, projectvalue, startdate
Task: taskid, projid, startdate, name, status
Projectvalue is ...
1
vote
0
answers
29
views
How to Sum by field on different table
I'm trying to create a measure that will Sum the forecasted and actual proceeds a client receives for all of the companies they own. Data model is structured in a star schema with Clients as the fact ...
0
votes
0
answers
14
views
Get / List Report Settings via API
I am looking for a way to get report settings through the PowerBI/Graph/Frabic/... API. I specifically interested in getting the 'Export Data' setting for a specific report. The goal would be to able ...
0
votes
0
answers
23
views
"we couldn't authenticate with the credentials provided" error in Power Query
I'm trying to get data from an API with bearer token authentication. I call this REST API successfully on Postman, but when I input it in Power Query, I get this error:
We couldn't authenticate with ...
0
votes
0
answers
15
views
Power Bi Integration with Rest API using selected slicer values
I have a deployed ML model. I am using a Flask app to use the model and return predictions. It is a post request which input payload in this form
{
"input_features": [
feature_list1,
...
0
votes
0
answers
25
views
Dynamic selection of columns that are to be displayed in a matrix in Power BI Dashboard
I would like to create a dashboard where the users of the dashboard can select the dimension columns and fact columns that they want to see the values for, and these should appear on the dashboard as ...
1
vote
1
answer
22
views
Why, when changing the double format to int64 in power bi, the memory occupied by a column decreases, but the total weight of the file increases?
I have a report in which one of the columns contains many unique integers. I saw that the data format is decimal (double) , I decided to convert this column to int64 (integer) format. In dax studio, ...