Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
wokka
Helper IV
Helper IV

Synchronizing unrelated calendars using slicer year value

I have two separate calendars in use on the powerbi and I want one calendar ( the Report calendar ) to force another calendar ( the Activity calendar ) to be its year value so the two unrelated calendars are synchronized.

 

What I wanted to do read the Report Calendar slicer value for the year e.g. '2024' and pass that automatically to the Activity Calendar as a filter for an existing visual table on the desktop, so when I change the Report calendar via slicer, the visual table on the page that uses the Activity Calendar will be automatically changed behind the scenes to be filtered by the Report Calendar year. 

 

I have disabled the connection between the report year slicer ( using Edit Interractions ) so the visual table is not affected by it.

I am not sure whats wrong.

 

What Ive tried so far as custom dimensions, but these dont appear to work :

------------------------------------

__TransferYear =

VAR  repYear = SELECTEDVALUE('Reporting cal'[year],0)

VAR Completion_year =
CALCULATE(  
       SUM('Reporting cal'[year]),  
       TREATAS(VALUES('Reporting cal'[year]),'Activity cal'[year] )
        )  
Return
       Completion_year

 

---------------------------

__TransferYear =
 
VAR SelectedYear = SELECTEDVALUE('Reporting cal'[year])
RETURN
    CALCULATE(
        COUNTROWS('<some table>'),
        FILTER(ALL('Activity cal'[year]),
        'Activity cal'[year] = SelectedYear
    ) )
 
Any help much appreciated..........
4 REPLIES 4
Anonymous
Not applicable

Hi @wokka,

As we haven’t heard back from you, we would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

 

Regards,
Vinay Pabbu

Anonymous
Not applicable

Hello @wokka,


Just wanted to drop a quick note, were you able to resolve the issue you raised?
If so, it would be really helpful for the community if you could mark the answer that helped you the most. If you're still looking for guidance, feel free to give us an update, we’re here for you!

 

Regards,

Vinay Pabbu

Anonymous
Not applicable

Hello @wokka,


Just wanted to drop a quick note, were you able to resolve the issue you raised?
If so, it would be really helpful for the community if you could mark the answer that helped you the most. If you're still looking for guidance, feel free to give us an update, we’re here for you!

 

Regards,

Vinay Pabbu

Rupak_bi
Super User
Super User

hi @wokka ,

the straight way to solve this is to have a relation between both the calenders. if there is some limitation, you need to create separate measures for all the values you wanna display refering to the other calender as filter. 

 

One more way you may try is to create a measure like

calender_filter = 
VAR SelectedYear = SELECTEDVALUE('Reporting cal'[year])

return

if(max('Activity cal'[year])=SelectedYear, 1, 0)

now use this measure in the filter pane of the table visual and sort it to 1. 

 

with limited understanding of the concern, this is what I think will work. A detailed explaination with images and sample data will be helpfull to solve exact problem.

 



Regards
Rupak
FOLLOW ME : https://www.linkedin.com/in/rupaksar/

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.