Forum Discussion
Matrix Table Custom
rbalza - so it turns out you cannot do what you want. I opened PBID this morning. I can supress the values, but in a matrix, the column will still show up as blank, which isn't desirable.
That is unfortunate. On a row, it would suppress the row value. The Matrix isn't as flexible as a Power Pivot table is in Excel.
Here is my PBIX if you want to see how ISINSCOPE is used.
Sorry - I was trying to remove it from the rows, I see now you only want the budget to show up at the column level. I was going the wrong direction. Use my measure, but use ISINSCOPE(Date[YearMonth]) column. Whatever it is that is returning May 2021, June 2021.
If that doesn't work, I'll need the PBIX file, which you can share with me via PM if it is confidential data if you are ok with that. Otherwise, I'm playing hit/miss here.
rbalza - so it turns out you cannot do what you want. I opened PBID this morning. I can supress the values, but in a matrix, the column will still show up as blank, which isn't desirable.
That is unfortunate. On a row, it would suppress the row value. The Matrix isn't as flexible as a Power Pivot table is in Excel.
Here is my PBIX if you want to see how ISINSCOPE is used.