20,640 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
1
vote
0
answers
24
views
PowerBI dynamic queries
I am trying to pull data from Jira into PowerBI using PowerQuery. I have a Sharepoint list of issue-ids that I use to create a JQL to call Jira and it works fine on the desktop. I can publish to the ...
-3
votes
0
answers
56
views
Powerbi Slicer option affects visualization [closed]
I am working in powerbi and I have a slicer with 9 domains, for example, finance, sell ect. I am showing the same bar chart for 8 of the domains. The values changes based on the domain, but it is the ...
0
votes
0
answers
37
views
Missing dates from two tables
I have two tables, Calendar and Sales. The Calendar table date range starts from 2023年01月01日 and goes to 2026年04月30日. The Sales table has this year's data starting from Jan'25 to the current date and it ...
0
votes
0
answers
25
views
CALCULATETABLE inside SWITCH in DAX
I have written the following DAX Measure:
Source Total Revenue - All Revenue - COSStoRevenue =
SUMX(
VALUES('Date Table'[Year Month]),
VAR IndST = SELECTEDVALUE('Individual Cost'[Cost Type])
...
1
vote
0
answers
15
views
Different Results in Power BI API Call
I'm quite new to Power BI API and I was planning to do something to refresh a dataset via API. I have setup the application in Microsoft Entra and able to get the token using Postman API.
I ran into a ...
1
vote
0
answers
28
views
How to unalign points on deneb line x axis?
Can someone help me figure out how to make it so the points below for City 3 are not aligned on the same x-axis, e.g., on top of each other? In the data, each occurs in its own row and has a Year or ...
0
votes
0
answers
40
views
How to change Table Row category based on Slicer?
I have a data model ("mainModel") loaded, and among the columns are "Parent Company" and "Sub-Companies" (in addition to many other columns, eg. "Values", "...
Advice
0
votes
2
replies
25
views
Dynamically display values on a ribbon chart controlled by a slicer
I want to be able to use a slicer on a ribbon chart that will dynamically display the values in millions/thousands. One total is quantity and the other is price. The chart will display yearly totals ...
Advice
0
votes
0
replies
15
views
Power Apps: Can we rename solutions and apps, and what Power BI license is required for integration?
I am very new to Power Apps and have recently learned how to perform basic CRUD operations. My organization has started a project using Power Apps, and I am trying to understand some fundamentals.
I ...
1
vote
1
answer
83
views
Cumulative DAX measure only works as expected when a date slicer is present
In Power BI, I have a semantic model with a fact table and a date table (marked as date table).
I have three measures.
One simply totals a column in the fact table: SalesAmount = SUM(FactInternetSales[...
1
vote
1
answer
87
views
Save DAX Expressions for later PowerBI Dashboards?
Is there some way to store commonly created DAX Expressions/Measures for use in multiple files?
I have a dataset that I refresh every month or so, and always have to manually add a few columns to the ...
0
votes
1
answer
65
views
Problem in SSIS package in DATA FLOW TASK section
I am placing the following command in a data flow task in an SSIS 2022 project, and the parameter I have is of type int(32) and the ReceptionDate_Shamsi column is of type char(10), and this causes my ...
0
votes
0
answers
56
views
DAX cumulative measure returns incorrect last month total when trying to optimize
I'm working on a Power BI report where I need to calculate cumulative account balances (OpenAccountsRunning) based on a per-month snapshot measure ([BaseClosing]).
I originally wrote this "fast" ...
0
votes
1
answer
124
views
DAX Query Filtering
I have one table(final Table) which has columns (date, volume, Month, resource) where I'm calculating the utilization of a resource. so,I need to have time which gets calculated as per below formula ...
-1
votes
1
answer
37
views
Is there a way to dynamically scale Line chart with multiple measures in powerbi to improve readability? [closed]
My main goal is to improve readability of my chart based on selected measures to be able to tell trends better. just a normal scaling, is this possible?
here is link to my sample dataset and pbix.
...