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
t-atgeor's avatar
t-atgeor
Microsoft Employee
10 years ago

Hi BhaveshPatel, thanks for responding. I believe I might have found a solution, however, do you happen to know whether it is possible to re-name a column name in the data source and after that automatically to use the new name in Power BI? If simply rename my data source column from Excel from Month to Fiscal Month, I get a message in Power BI that the column Month could not be found.

 

I would simply like to substitute it without affecting my graphs.

 

Thanks, Atanas

  • BhaveshPatel's avatar
    BhaveshPatel
    Super User
    10 years ago

    Seems strange. It does pick up the new name after the refresh as always happened to me.

     

     

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

      BhaveshPatelNot always, apparently, I also assume it might arrive from the Date format, tried manually in separate excel files, with the Date format (mm,dd,yyyy), and even though both columns have same naming, same date format, PowerBI cannot create the relationship. Any special setting to that?