Forum Discussion

veng2002's avatar
veng2002
Frequent Visitor
8 years ago

Matrix issues

Hi,    I'm trying to accomplish multiple things here... 1) I have a status (row) for each record that I have (Open, ongoing, closed) and I'm trying to get a Matrix that will show the values for ea...
Need Help
v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

veng2002

 

1. I assume your Value for each status per week is a measure. Then you can apply IF condition like: 

 

=IF([Value]=BLANK(),"static",[Value])

2. You can use relative Date Slicer. 

 

 

Regards,

 

 

  • veng2002's avatar
    veng2002
    Frequent Visitor
    8 years ago

    Hi Simon,

     

    Thanks for your reply :)

     

    1. Not working. Yes, my value is done with a measure. Using your approach does not give me the zero values, from your formula is checking if I'll get a blank value, but my status rows will always have a value. Dont know if you're measuring on a different way - maybe counting each status?

     

     

     

    2. This is a great slicer, didn't know about it and I think it's awesome. However, even though I'll use it I did not explain myself correctly. What I want to accomplish automatically is that the matrix only shows the last 5 weeks but without the use of a slicer. I dont know if building a measure that somehow calculates the number of existing weeks and substract the number -5? So the matrix updates every week and only shows the data for the last 5?

     

    Regards,