Forum Discussion
Numbers in Matrix Table become blank after adding slicer selected value as column
Just started using PowerBI for a short time. I am adding a constant date column refelecting slicer selected value into Matrix table. It serves as a bench mark date for calculating as-of overdue date....
Update:
Just filter out empty number columns and the result is what I expected. So it's a solution for me.
Thanks so much for comment above. As this constant column only change with slicer so I should not assign relationship for it.
Hi Alxis,
Thanks for your prompt reply.
However my scenario is let user choose a future date (coming 10 years) which will be beyond most of "Start date" and some of "Completion date" in FACT table. And also this picked up date has nothing to do with any date in FACT table actually. I am not sure if such relationship is appropriate.
Just need to display this slicer date in every row and use it to calculate a as-of overdue date accordingly. Of course I will try also your solution first. Thanks!