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
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.

      • v-gizhi-msft's avatar
        v-gizhi-msft
        Community Support
        6 years ago

        Hi,

         

        Please try this measure:

         

        Measure = IF(MAX('Table'[Year])=SELECTEDVALUE('Calendar'[Year]),1,0)

         

        Then apply this measure to the visuals by setting measure=1.

        The result shows:

        See my attached pbix file.

         

        Best Regards,

        Giotto