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 us to select year and filter displayed data. Visual's dataset is NOT linked to calendarauto() table.

Is there any way to create a link between the slicer and this visual, so selecting year on the slicer would filter the data?

Need Help

9 Replies

  • Pragati11's avatar
    Pragati11
    Super User
    6 years ago

    Hi Anonymous ,

     

    You can create a YEAR column in Calendar Date table. Then use this column to establish a relationship between you data-set and Date table.

    This will make slicers work the way you are looking for.

     

    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

      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