Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Stacked Column Chart - including data from table with two different date columns

Hello,   I have a Power BI report with 3 maine tables: PA, NAV and  Date. The date table is used to filter by year in my report, therefore, all the other tables are connected to it through their Da...
Need Help
  • MFelix's avatar
    MFelix
    6 years ago

    Hi Anonymous ,

     

    The calculation here needs to be done with the inactive relationship has is referred on the blog you shared.

     

    If you create an inactive relationship between the Date table and the PA date updated using the USERELATIONSHIP you can get the information on that column and not on  the active relationship.

     

    Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

    If the information is sensitive please share it trough private message.

MFelix's avatar
MFelix
Icon for Super User rankSuper User
6 years ago

Hi Anonymous ,

 

The calculation here needs to be done with the inactive relationship has is referred on the blog you shared.

 

If you create an inactive relationship between the Date table and the PA date updated using the USERELATIONSHIP you can get the information on that column and not on  the active relationship.

 

Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.