9,735 questions
Advice
0
votes
0
replies
12
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 ...
0
votes
0
answers
66
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[...
- 3
1
vote
1
answer
83
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 ...
- 23.5k
0
votes
0
answers
55
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” ...
- 31
0
votes
1
answer
123
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 ...
- 13
-1
votes
1
answer
34
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.
...
Advice
0
votes
1
replies
35
views
Check last 12 months based on slicer
I need to make a simple check in a measure.
I have a table similar to this:
MonthYr
Flag
1/1/2023
0
2/1/2023
0
3/1/2023
0
4/1/2023
1
5/1/2023
1
6/1/2023
0
7/1/2023
0
8/1/2023
0
9/1/2023
0
10/1/2023
0
...
- 412
-1
votes
2
answers
73
views
Reference Slicer option in Calculated Column
I am trying to anonymize data, except for the company that's selected in a filter.
Sample data is below:
Company Name
Anonymous Name
[Calculated Column]
Coca Cola
Company A
Wayne Enterprises
Company B
...
- 23.5k
0
votes
0
answers
30
views
Calculating the year to date sales of the previous year in a matrix visual
I have a matrix visual which is based on a view v_Umsatz. The visual uses the year as the columns and the customer as the rows. For every year I want to calculate the sales amount up until the current ...
- 13
Best practices
1
vote
0
replies
32
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 ...
1
vote
1
answer
54
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
1
answer
46
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
2
votes
2
answers
120
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, ...
- 23.5k
0
votes
0
answers
56
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 ...
- 57
0
votes
0
answers
34
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
1
vote
1
answer
84
views
AND filter across multiple tables
I'm trying to create a measure in Power BI using DAX that filters across two different tables using AND but I can't seem to get it to work. It seems like such a simple thing but I can't seem to find a ...
- 31
0
votes
0
answers
51
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 ...
1
vote
1
answer
64
views
Get Row, Col value of RELATEDTABLE in DAX
In DAX I can use RELATEDTABLE to get a table of data I want to refine.
I can use FILTER to reduce the table to 1 row that contains the data I actually want.
I can use COUNTROWS to verify that I have 1 ...
- 884
0
votes
0
answers
54
views
Elegantly suppressing aggregated data points in a clustered column chart representing fewer than a given 'n' of records
I have a fairly large (long) dataset that looks something like this... one record per individual response to each part of each question:
ID
breakdown_1
breakdown_2
question
question_A_or_B
value
1001
...
0
votes
0
answers
48
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
-3
votes
1
answer
43
views
grouping of items sales price with with qty sold and total sales [closed]
I need help in recreate the report that's done in MS Access in Power BI.
I'm trying to get the quantity sold, total sales amount, etc. by the item sale price that fall into the different ranges.
All ...
- 67
0
votes
1
answer
37
views
How to make a dependent slicer auto-reset when the current selection becomes invalid
I have two slicers:
Year from Calendar[Year] (values: 2023, 2024, 2025)
PlanType with two items: Planned and Actual spent
Data:
I have Actuals for 2023–2024, but no Actuals for 2025 (only Planned).
...
- 65
0
votes
0
answers
38
views
Rank Function - by measure over multiple columns
I want to make a measure that returns the rank of the current Reason×Resource by [Qty_Sum], respecting page/report slicers.
Qty_Sum =
[Qty_2025_W38] + [Qty_2025_W39] + [Qty_2025_W40]
...
- 83
0
votes
0
answers
45
views
Power BI - MIN/MAX Issue
I have the following matrix in Power BI with the measures "First Period", "Second Period", "<> Change", and "% Change" (the DAX code for the First Period ...
- 21
0
votes
0
answers
29
views
Power BI Dax Measures Renaming AUtomation
I have recently started working as a Power BI Developer. I was given a task of renaming dax measures present in the model. There are more than 50+ dax measures. Now the task is to automate this ...
- 1
2
votes
0
answers
61
views
PowerPivot Measure - Average subgroup w/ Top N applied?
I am trying to calculate the difference of each "Row" value from that group's average from a group of two Top N filtered values.
I am able to successfully "pull down" the average ...
- 23.5k
0
votes
0
answers
66
views
Error occured while running DAX in Power BI which is connected to SSAS using live connect mode
I have connected my SSAS with MS Excel and all the dax which i am running is working fine .
Image of DAX result in MS Excel
But when i am connecting the SSAS with Power BI it is not running as ...
0
votes
1
answer
43
views
Power BI Filter rows to remove nulls based on a condition
I have a combined table powering a PowerBI report that has an issue with almost duplicate rows.
I have 2 records for certain SubIDNo entries, but for one of those I don't have a DateChecked. They all ...
- 117
0
votes
1
answer
47
views
Calculating the right ratio in a matrix with subrows in Power BI and DAX
I'm dealing with the following situation in Power BI.
I have a matrix where:
Rows contain client names (sales[cardname])
Subrows contain the products related to each client (sales[itemname])
I'm ...
- 1
1
vote
1
answer
49
views
Filter date using bookmarks PowerBI
I would like to change the date daily by clicking on the arrow.
Selected date should be changed daily by clicking on the arrows. Is this even possible ? many thanks in advance.
I need something more ...
- 3,031
1
vote
0
answers
61
views
DAX Year To Date Cumulative Total
I am fairly new to DAX and am coming across a problem I cannot solve.
I have a SSAS Tabular Cube and am trying to create a YTD cumulative total which, fort the most part, works as expected. However it ...
- 11
2
votes
1
answer
97
views
How to allow a visual row to access all rows of a particular column in the visual?
I have a visual using columns from the Timesheets and Users tables, using the relationship on [_userID] (Users-to-Timesheets, one-to-many, single). Each row of the visual is uniquely defined by ...
- 264
0
votes
0
answers
34
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
45
views
Measure to average all rows in Power Bi matrix
I want to add a meaure that averages the STORE COUNT column for all rows in attached Power BI matrix.
The STORE COUNT column is a Count summarization in the Values section of the matrix.
I would like ...
0
votes
1
answer
43
views
How to update a Power BI Template
Months ago I have downloaded the:
Microsoft Fabric Capacity
Microsoft Fabric Chargeback Reporting
The version I have are the following:
It seems to me that I have a discrepancy between my version ...
- 12.8k
1
vote
1
answer
106
views
Power BI / Microsoft Fabric Semantic Model – “Sort by column” not working
Screenshot from DAX Studio
Screenshot from Semantic Model
I’m working in a Microsoft Fabric Semantic Model (same behavior as Power BI Desktop model) and I’m trying to sort one column by another using ...
- 11
0
votes
2
answers
67
views
SSAS Tabular grand total wrong with hierarchy filter
I am using SSAS Tabular 2022 and has model as below:
The total amount is calculated as
Total Amount:= sum(Amount[Amount])
When I view in Excel and filter the model by the Year-Month-Date, the first ...
- 9
1
vote
1
answer
80
views
Nested ranking of sales in Power BI
I am trying to rank sales by customer and product in a matrix. I have a traditional star schema with a fact table and dimensions for date, customer, and product (a few more but not relevant). On the ...
- 59
0
votes
0
answers
32
views
Creating a Line graph & Matrix showing % Difference from Previous Year, allowing for a filter on "Country"
I have raw data with columns "Year", "Period", "Country", "Sales Amount". Please note there are 13 periods in a year, (and not 12). The dates also differ ...
- 1
0
votes
1
answer
60
views
MS Excel DAX SWITCH Based on Row Value
I haven't used DAX much but I thought this would be easier. Basically I have the value [ID] in the rows of a pivot table using the data model function, and then the values [Numerator],[Denominator], ...
- 325
2
votes
1
answer
80
views
Issues with DAX measure not showing row values in the table
I have a DAX measure that tries to find the previous weeks target and is used to subtract from the present week target to get me total change. The measure does not show any row values. It worked prior ...
- 31
0
votes
0
answers
92
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 ...
- 15
1
vote
2
answers
143
views
Count consecutive rows in Power BI that have a value. Get start date and max grade from that group
I have a table with the following data:
record_id
visit_date
int_date
month
hb_ae
wbc_ae
anc_ae
plt_ae
ast_ae
alt_ae
arc_hb_ae
sched
10
9/9/2015
7/8/2015
1
2
Sched
10
10/9/2015
7/8/2015
2
2
Sched
10
...
- 397
1
vote
0
answers
42
views
How to show both count and total price with Date Slicer?
I’m working on a Power BI report and using a Sankey diagram with ChartExpo Sankey, Visio Chart Sankey, and Microsoft Sankey (from AppSource).
I want the Sankey to display both the count of items and ...
- 11
0
votes
1
answer
60
views
Average (measure) based on most recent date
My Power BI model has a single table. I cannot create any new calculated table.
I need to develop 2 measures in the DAX language, one for Salary of an employee based on most recent effective date; the ...
- 465
0
votes
1
answer
52
views
Reporting m to n Jira issue types
My problem is an m to n relationship between the issue types "Epic", "Story" and "Bug". So a Bug can be a child of a Story, or a child of an Epic. But in some cases it is ...
jira
1
vote
1
answer
172
views
Dax query with IN operator using multi valued parameter Power BI report Builder
I need to create filter for table using parameter(working on report in Power BI report builder). So I have one main dataset and one dataset for parameter values where also was created row for all ...
- 47
1
vote
1
answer
84
views
Filter table by Last entry per day per ID
I have a table which has an entry for every time a ticket is assigned to an agent or team. What I need to be able to do is find latest datetime for each faultid per day. Table is similar to below
...
- 13
2
votes
0
answers
99
views
Matrix table in power bi
I have a table Feature_Site, I want to count the featureCode by FeatureStatusDescription, I already have a measure that gives me the feature count
Totl_features =
COUNT ( Feature_Site[FeatureCode] )
...
- 57
2
votes
2
answers
80
views
How do to distinct count by time period with a DAX measure
I have a dimension table with column Account ID
Account ID
a
b
c
and fact table
Merchant
Account ID
Date
Value
1
a
January
500
2
a
February
100
2
b
February
300
2
c
January
200
3
a
January
900
3
b
...
- 21