Forum Discussion

dbrandone's avatar
dbrandone
Icon for Helper IV rankHelper IV
5 years ago

Need Help with relationship and date drill down issues

I have a weird report that I was asked to make and it uses not ideal data, but I have put it together but one measure will not interact with a date slicer that I have on the page. I only have 3 table...
Need Help
v-henryk-mstf's avatar
v-henryk-mstf
Icon for Community Support rankCommunity Support
5 years ago

Hi dbrandone ,

 

Based on your description, first I suggest you read the following documents on how to create relationships for complex tables.

related document link:

Understand star schema and the importance for Power BI - Power BI | Microsoft Docs

Create and manage relationships in Power BI Desktop - Power BI | Microsoft Docs

 

If there are still problems, please provide relevant data model and demand information, I will answer you as soon as possible. Looking forward to your reply.


Best Regards,
Henry


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • dbrandone's avatar
    dbrandone
    Icon for Helper IV rankHelper IV
    5 years ago

    v-henryk-mstf 

     

    Below is a picture of the relationship setup.

    The Date from the Date table is connected to the Date in BadgeAccessData. Date intelligence between these two work fine. When I try to use date intelligence using the same filters, data from Health Check does not change. The data sources used in this makeshift report are not ideal and there are no unique identifiers in either of the two data source tables. They are connected via Office365 username. This is why I needed to use many to many to get these to work the best possible so far. If I add a relationship from Health Check to the Date table, I get the inactive message since BadgeAccess is already connected, but I am not getting the results as if they were connected.