Synchronizing unrelated calendars using slicer year value

[wokka]

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

[v-vpabbu]

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

[v-vpabbu]

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

[v-vpabbu]

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]

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.