Forum Discussion
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...
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
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?
Hi,
It is because i created relationship between them which will break the calendar hierarchy.
Please check my attached file again.
Best Regards,
Giotto