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