Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Create arbitrary link between visuals

Lets say we have a data set which has "year" among other dimensions (not the datetime - year as integer), and visual built upon this dataset. We also have a calendarauto() based slicer which allows u...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Relationships are out of question because of the dreaded "circular relationship" error. We just cannot create them when needed.

Pragati11's avatar
Pragati11
Super User
6 years ago

Hi Anonymous ,

 

Is there an existing relationship betwwen your Date table and data-table? Or are these individually connected to any other table?

Can you try pasting a screenshot of the data model with relationships in Power BI here?

 

If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

 

Thanks,

Pragati

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    There is no relationship (within the model).

    • Pragati11's avatar
      Pragati11
      Super User
      6 years ago

      Hi Anonymous ,

       

      Can you paste your sample data here, along with the datatypes the columns have in both tables?

       

      Thanks,

      Pragati

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        I cannot post the sample data because, if I only recreate 2 tables the answer would be "create a relationship". But as I've already mentioned above, creating relationship is out of question because this would create circular relationships.

        The question is rather simple. There is a CALENDARAUTO() - based slicer that lets you select years. There is also a table that has a "year" column (integer) and other data, and visual built using this table. The goal is: slicer should filter the visual.