cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PBIUWO
Helper III
Helper III

Alternative way to display all columns in a Matrix?

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? 

1 ACCEPTED SOLUTION
v-xulin-mstf
Community Support
Community Support

Hi @PBIUWO

 

You can try measure like:

Measure = 
CALCULATE(
    SUM('Table'[sales])+0,
    'Table'
)

 

Best Regards,

Link 

View solution in original post

2 REPLIES 2
v-xulin-mstf
Community Support
Community Support

Hi @PBIUWO

 

You can try measure like:

Measure = 
CALCULATE(
    SUM('Table'[sales])+0,
    'Table'
)

 

Best Regards,

Link 

View solution in original post

negi007
Super User II
Super User II

@PBIUWO  i guess you will have to use show items with no data value in this case. else you will have to have one zero record against months where there is no sale volume. 




Did I answer your question? Mark my post as a solution!
Appreciate your Kudos


Proud to be a Super User!

Follow me here


Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors