Forum Discussion

t-atgeor's avatar
t-atgeor
Microsoft Employee
10 years ago

Cross table filtering

Hi,   I am having an issue establishing a relationship between two tables, and including a cross page/report filter. For some reason, even though both attributes are based on Month level (e.g Janua...
Need Help
Anonymous's avatar
Anonymous
Not applicable
10 years ago

Hi t-atgeor,

Firstly, could you please share sample data of your tables and post the screenshot about that how you create relationship between the two tables in Power BI Desktop?

Secondly, you can directly change column name in Query Editor  of Power BI Desktop, just right-click the column you want to change and select “Rename”  as shown in the following screenshot. Changed column name will be automatically reelected in your graphs.


Thirdly, the above error message is caused by that you have primary key on your column and the value you are trying to create the relationship on is not completely unique. Please check duplicate values in your column.


Thanks,
Lydia Zhang

  • t-atgeor's avatar
    t-atgeor
    Microsoft Employee
    10 years ago

    Hi Lydia,

     

    thanks for your response. I have managed to solve the issue by creating a third table with unique values and connecting these values with the other two tables in relations One to Many. However, since both of my initial two tables have duplicates, I find it challenging to establish a direct relationship between them, something which I can solve with a third table. Regarding renaming, the issue is not in the Renaming of the column in PowerBI, but once I rename the column in my source data (e.g Excel), then PowerBi does not capture the renamed column and state it as an Error. So I have to come back to Excel and rename the column in the same way as in PowerBI.

     

    Thanks and Regards,

     

    Atanas