Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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 

negi007
Community Champion
Community Champion

@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 on linkedin

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.