Tabular Visualization

[Anonymous]

Hi,

Need help with representing the following visual,

Where A is a measure and is calculated for the present month and is a day by day comparison across the years(Present and Last). This is a MTD report and hence has no date slicers. I used a calculated column to represent the Date to only show dates from 2018 i.e. from my calendar table, only fetched dates of 2018 for visualization purpose .Day is taken from Calendar table (Date.Day). When I fetch Day description from my calendar table, I get description for 2017 days as well. I want the description only for the days of 2018. How do I tackle this?

[Greg_Deckler]

Would have to see some sample data. You should be able to filter your visual or your measure to only include 2018.

[Anonymous]

Days description is a column from Calendar table. It is not a calculated column or measure.