20,652 questions
1
vote
1
answer
99
views
What is a more efficient way to take results of a query in a tabular model and use that to query additional models?
I need to filter two separate tabular models and return a table of summarized results from each, using values retrieved from a third semantic model for calculate context. The process creates a data-...
- 470
-1
votes
1
answer
100
views
How to add same index column for every 10 rows [closed]
My csv file have one column with multiple rows.
I read that file in power bi desktop and try to display as paginated report .
The design I want to display is I like to show every 10 record as one page ...
- 4,588
1
vote
0
answers
173
views
Connect-PowerBIServiceAccount is not acting as expected
The ask is to authenticate and pull the data from PowerBI using MicrosoftPowerBIMgmt v1.2.1111 in PowerShell. TLS auth is strongly encouraged.
Prerequisites: upgraded to PowerShell v7.x since PnP was ...
- 1,005
2
votes
1
answer
76
views
How can I summarize sales data by category in a new column?
I would like to create a new column where I can sum units by quarter.
My table like this
Another column I would summ unit by product and quarter
Edit: Last two col with the expected result
Unit
...
- 53
2
votes
1
answer
55
views
Power BI: DAX measure to calculate portfolio, benchmark and excess returns in a matrix filter context
I have a table containing the monthly returns of a portfolio, its benchmark and the monthly excess (portfolio - benchmark).
Table 1 extract
| Date | Attribute | Value |
|----------------|----...
- 63
1
vote
1
answer
133
views
Card (New) Visual – Show Scaled Numeric Value (K/M/B) with Conditional Arrow Indicator
I'm visualizing totals using the Card (New) visual in Power BI, and I’d like to add an arrow:
Up arrow when the value is positive
Down arrow when the value is negative
I can achieve this by creating ...
- 65
0
votes
1
answer
55
views
Power BI measure for cumulative count/sum over all related rows at the current hierarchy level and below
I have this table say 'Table' with a column in Power BI that contains a piped path of strings such as 'Level1|Level2|...'.
This column is expanded into multiple fields [Level 1], [Level 2], ... ...
- 114
0
votes
0
answers
68
views
Not able to execute DAX on PowerBI in .Net through ADOMD Client
I have the below python code which works perfectly on any Workspace by executing the DAX on powerbi Dataset, whereas i converted this in .Net, but its failing and giving Not Found error. Can someone ...
- 404
0
votes
0
answers
87
views
Paginated report (power bi report builder) take along time to fetch data
I created a power bi report builder
I used a sample query to get data from one table
EVALUATE SUMMARIZECOLUMNS (
'InventRepriceJourTransEntity'[ItemId],
'InventRepriceJourTransEntity'[...
1
vote
1
answer
77
views
Power bi DAX query SWITCH error not working
Hi I am trying to add colour to my chart to be red if above UCL or Green if below LCL. I keep getting this error. Any advice please?
`Query (2, 2) The syntax for 'SWITCH' is incorrect.
(RateColour =
...
- 23
-1
votes
1
answer
161
views
OAuth/SSO to Snowflake with Power BI and Airflow
My team is changing all our Power BI and Airflow users' Snowflake connections to use OAuth and SSO. Anyone have experience doing this with these 2 tools?
Far as I can see for Airflow, we register an ...
0
votes
0
answers
30
views
Invalid token in Tosca API testcase when passing a DAX query
I'm automating PowerBI API requests in Tosca. The query I want to execute as payload of a Postrequest is working fine in Postman and also in the API scan module of Tosca but when exporting the API ...
user28080598
0
votes
2
answers
64
views
Creating data model in Power Query to map lists of fields to nested subset of JSON data
I'm attempting to create a Power Query data model with some unpleasantly-formatted JSON data, and would like to present it more logically to its consumers.
This is a heavily simplified abstraction of ...
- 3,648
0
votes
1
answer
112
views
How to embed a report set to a bookmark?
Not sure if this is possible but I'm trying to embed my Power BI report into a sharepoint page and set it to a certain bookmark. However when I copy the URL into the report embedment panel it just ...
- 183
0
votes
1
answer
73
views
Dynamic Power BI Matrix
Goal: I'm trying to recreate in Power BI a weekly project ranking matrix that mimics the Excel table below. The goal is to show project data ranked by amount per calendar week with each matrix cell ...
- 25
0
votes
0
answers
39
views
Added a remark column to my current matrix table, now no data is showing
I recently added a "Remarks" column to my matrix table. Since then, none of the data is
displaying in the visual,
Report View
even though everything looks fine in the data table itself. The ...
0
votes
1
answer
74
views
How do I determine inactive users in a specific period, using DAX/PowerQuery/CalculatedTable?
I have a fact and a dim table as shown below. Expected Table/DaxCode/Powerquery should answer how many & which users were active & inactive in 6/28/2025.
Fact table
ID USER ACTIVE USER ...
- 3,031
2
votes
1
answer
88
views
Modifying the colors in David Bacci's PowerBI Deneb Org chart
I am trying to modify David Bacci's Org Chart. https://github.com/PBI-David/Deneb-Showcase/tree/main/Organisation%20Tree%20Chart. My goal is to change the color of the node borders based on ...
1
vote
0
answers
59
views
Dynamic Grouping with Dynamic Slicers PowerBI
I have a dataset with sales data for some time:
Company
SubBrand
Analytical Name
Sales
Market
Company A
Brand 1
Product 1
Num.
Market A
Company A
Brand 1
Product 2
Num.
Market B
Company B
Brand 2
...
- 11
1
vote
0
answers
48
views
How to show "PAST" (before today) + next 12 months with MMM X-axis labels
I'm trying to build a bar chart in Power BI where the X-axis shows the following:
A "PAST" bucket representing all data before today
The next 12 months, displayed as 3-letter month names ...
- 49
-1
votes
1
answer
55
views
Automatic Jira ticket creation from powerBI
I have made a powerBI dashboard essentially that will update and show us certain errors in our software and their frequency over a number of days ie this specific error has occurred over 5 times over ...
- 45
0
votes
1
answer
108
views
How to validate DAX queries in .NET before executing against Azure Analysis Services?
I’m working with a client who wants to reduce the execution time of my application when making multiple DAX calls.
Currently, the flow is:
I use an LLM to generate a DAX query based on report ...
- 11
0
votes
1
answer
44
views
Is there a way to include multiple arguments in DAX when creating a calculated column?
I am trying to create a calculated column using DAX in powerbi with multiple conditions. I wrote the below query using Switch function but it only accepts two arguments. Is there any way I can change ...
- 207
1
vote
1
answer
89
views
Power BI DAX measure to create a percentage from two measures
I have the below measure where I'm trying to get a percentage total from two variables. However i keep getting an error message where it says the function cant compare date and text values. even ...
- 183
1
vote
1
answer
49
views
How to group/summarize and sum the amount of the lates date in DAX
I have a sample data as below. I would like to GroupBY Group1 and Group2 variables, SUM the amount and only keep the Max(Date) using DAX. Many thanks in advance.
Group1 Group2 Date Amount
A1 ...
- 3,031