Forum Discussion
Solved
Filtering out future dates while not suppressing zeros in visual
Hi Power BI community,
I have a bar chart visual, and some yyyy-mm have zero/ blank values, but I'd like the bar chart visual to show all the yyyy-mm without skipping (suppressing) zero/ blank ...
This issue was resolved by filtering out future dates in the calculated calendar table.
Hi Bmejia
Thanks for your comment, but I am not using yyyy-mm to filter the visual, and I am trying to filter the visual using "Past date" field which is a calculated column in 445 Calendar table. Despite the selection of "Past date" the filtering is not behaving in the way intended.
This issue was resolved by filtering out future dates in the calculated calendar table.