Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Issue in relationship between two direct query tables

Hello, I have an issue with an older report. There are three tables connected and i have got an issue between table BeginnReasonCodeNeglist (table1) and Engagement (table2). Table1 is a reference table in the initial report i used a value of the table1 as an filter. But this isn't working anymore. Using the functions related() and calculate() isn't working anymore ethier. If I rebuild it from scratch it is working again.

I had a look in the model-view and i noticed that the colors on top of the tables are slighty different. table1 has a dark green and the other a lighter green. What does that mean?  Does anyone have a clue? 

 

Need Help

1 Reply

  • v-jingzhang's avatar
    v-jingzhang
    Community Support
    5 years ago

    Hi

     

    The colors in the table card headers will automatically match the colors you've selected in any report theme you're using (Reference: Model view in Power BI Desktop). Based on my test, tables of the same storage mode have the same header color. 

     

    What is the storage mode of the table1 and table2? In which table are you using the related() function?

     

    Regards,
    Community Support Team _ Jing

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