Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Matrix: Getting rid of blank spaces

Hi everyone,  I am trying to build a Matrix with two different categories A and B as 'Values' in the  visualization panel and months as columns.  I am doing this, because I want to put a different c...
Need Help
Tips and Tricks
suparnababu8's avatar
suparnababu8
Icon for Super User rankSuper User
2 years ago

Hi Anonymous 

 

By using ISBLANK function you can handle the blanks
First create this measure to handle blanks as zero's. 

A = IF(ISBLANK(SUM(Table[CategoryA])), 0, SUM(Table[CategoryA]))
B = IF(ISBLANK(SUM(Table[CategoryB])), 0, SUM(Table[CategoryB]))

 

Then you create this easure 

CategoryALastYear = 
CALCULATE(SUM(Table[CategoryA]),
    SAMEPERIODLASTYEAR('Calendar'[Date])
)

category B 

CategoryBLastYear = 
CALCULATE(SUM(Table[CategoryB]),
    SAMEPERIODLASTYEAR('Calendar'[Date])
)

 

Then, drag the new measures (CategoryALastYear and CategoryBLastYear) into the Values field of your matrix visual.

Hope this helps you!