Forum Discussion
Issue with visual not showing some data for specific year, while the measure displays the total
Hi,
Expand the filter pane to ensure that there is no active filter. Also, if there is already an active relationship between the Quote year and Dae column, why are you using the TREATAS() functiona at all. A simple SUM() function should work.
If neither helps, then please share the download link of the PBI file.
You need to connect the columns on the same identifier - so that's to say either connect them both on date (recommended), or connect them on year. I recommend connecting on date because otherwise it will become a many:many relationship which may cause issues further down the line.
Yes they are connected by date. The relationship can be seen here:
The 'Quota's year' which is a date column, is connected to the 'Date' column of the calendar table. Even with that I don't see the right data.