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
Joe_Barry's avatar
Joe_Barry
Icon for Solution Sage rankSolution Sage
2 years ago

Hi Anonymous 

 

Do you have the categories in the column field? if yes, then this expected behaviour. It will happen too, if you put it in the rows.

 

Regarding the calculations:

If your data model is set up in a Star schema and you have a date table, these measures will help you.

TotalYTD = 
TOTALYTD(SUM(Table[Amount]), Date[Date]) 
TotalPY =
CALCULATE(
    [TotalYTD], 
      DATEADD(Date[Date], -1 , YEAR)
)

 

Just add the Category to a visual and both measures. Use the Columns from the Date table in all visuals and slicers.

 

Joe