Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Background:
I have a report where there is a Matrix and a filter.
Within the Matrix, there are items on the rows, and Month/Year on the columns. The values are the sales per month.
*The data source will only show the previous 12 months.
The filter is used to filter the Item codes that are on the rows.
For some items, they do not have any sales for each month, so the columns would skip the months that have 0 sales.
Question:
Without using "Show Items WIth No Data", how can I display the months for that have 0 sales?
(I can't use Show items with no data, because it causes the visual to show the no memory error)
*would I just have to place a 0 for all of the sales are blank?
Solved! Go to Solution.
Hi @PBIUWO
You can try measure like:
Measure =
CALCULATE(
SUM('Table'[sales])+0,
'Table'
)
Best Regards,
Link
Hi @PBIUWO
You can try measure like:
Measure =
CALCULATE(
SUM('Table'[sales])+0,
'Table'
)
Best Regards,
Link
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |