I have a table where I want to show data for for instance Feb 2017 but also a running total for all categories not just those with data in Feb 2017. I have a slicer in Power BI to select the Feb 2017 data. When this is selected I can only see categories that have data. What I want to do is replicate the behaviour of a pivot table 'show items with no data'. There seems to be an equivalent in Power BI 'show items with no data' but this does not work.
excel pivot table before 'show items with no data'