Forum Discussion

aasamassa's avatar
aasamassa
Advocate I
8 months ago
Solved

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 ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    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.

srlabhe's avatar
srlabhe
Super User
8 months ago

Try changing join to Bi Directional

aasamassa's avatar
aasamassa
Advocate I
8 months ago

Just tried but no luck, I still have the same issue.

  • srlabhe's avatar
    srlabhe
    Super User
    8 months ago

    Follow below steps for debugging the issue

    1. Take a blank canvas in PBI report add Table Visual

    2. Identify for which date the data is there in both the tables 

    3. Filter Table visual for that date and add both fields from both tables in Visual where you have created the join

    4. Add the measure you wanted to see and slowly keep on adding another columns.

     

    You should be able to recreate the issue and knwo which column/or measure has creating it to get data disappear for the date.

     

    All the best