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

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    I cannot even reproduce this configuration in actual file. In your example, CALENDARAUTO-based table has no year/quarter/month fields - somehow, because in real file it is impossible to remove fields or edit CALENDARAUTO() hierarchy in any way.

    How did you delete hierarchy from calendarauto?

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

    Hi,

     

    It is because i created relationship between them which will break the calendar hierarchy.

    Please check my attached file again.

     

    Best Regards,

    Giotto