Forum Discussion
aasamassa
8 months agoAdvocate I
Issue with visual not showing some data for specific year, while the measure displays the total
I have a table for quotas and a central table for the dates. They are joined by the columns 'quota's year' and 'Date'. Below are sow extracts of the two tables and how they are linked. Rep ...
- 8 months ago
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.
ExcelMonke
8 months agoImpactful Individual
This is interesting, and can you confirm that the two columns you are linking on are the same datatype?
aasamassa
8 months agoAdvocate I
Yes they are both linking on a 'Date' format