How to use the outcome of a numeric parameter on all sheets in a report

[rpinxt]

I have made a simple numeric parameter/slider:

Set up like : 

P-Rate = GENERATESERIES(1, 1.3, 0.01)

So between 1 and 1,3 with steps of 0,01.

Lets say I have 2 sheets, Sheet 1 and Sheet 2.

On Sheet 1 there is the slider as show above.

When I reference the outcome of the slider on a card on sheet 1 it gives 1.10 as expected.

On Sheet 2 I do not have the slider but I do have the card and the outcome of the card is (blank)

That is a problem because I am using this formula:

Tot.GC = [Tot.LC] * 'P-Rate'[P-Rate Value]

On sheet 1 this works just fine. Tot.LC gets multiplies with 1.10

But on sheet 2 this goes totally wrong.

It does not get multiplied with 1.10 but with 0.01 which is with the step.

Surely there is a way to set the rate only once on any given sheet and then make sure on all other pages Tot.GC gets calculated correctly??

[parry2k · Accepted solution]

@rpinxt you can use sync slicer and hide the slicer on other pages so that it is only on one page but the changes/selection is reflected on all the pages where the slicer is synced.

[parry2k]

@rpinxt, let me clarify one thing about what @Bibiano_Geraldo said. It surely creates a disconnected table, but the behaviors of using slicers with disconnected table or a connected table are the same. Glad you have a solution and this is the only solution (sync and hide)

[Bibiano_Geraldo · Accepted solution]

Hi @rpinxt ,

the issue here is that GENERATESERIES creates a disconnected table, and when you use a slicer on Sheet 1, the selected value is applied only in that context. Since Sheet 2 does not have the slicer, no selection exists, leading to unexpected behavior where the default value (often the minimum step, 0.01) is used instead.

What you need to do, is just copy the slicer from sheet1 and place on sheet2, and then go to View Tab and click on sync slicers as bellow:

Now in the sync panel make sure that the both pages as sync:

You can learn more about sync slicers here

[rpinxt]

Great explanation @Bibiano_Geraldo ! Always good to have a bit more context why power bi is behaving like it is behaving 😄

This looks indeed to be the only way so I am implementing this now.

Thanks again all for the help.

[MattiaFratello]

What if you copy and paste the slicer but you keep it not visible in the second sheet?

[rpinxt]

Yes thanks @MattiaFratello , that a bit like pary2k said.

Look like the only way to do it.

[parry2k]

@rpinxt read more about sync slicers here Enable the Sync Slicers feature in Power BI visuals - Power BI | Microsoft Learn

[parry2k · Accepted solution]

@rpinxt you can use sync slicer and hide the slicer on other pages so that it is only on one page but the changes/selection is reflected on all the pages where the slicer is synced.

[rpinxt]

Ok thanks @parry2k . So you will always need to put the slider on the othe pages. That is a pitty.

But at least with the hide option you cannot see it.

Would have thought pbi would have an option to reference a slicer anywhere in the report and use the outcome of that in calculation.

But ok.