Forum Discussion
User Entered Value Across All Pages
Hi NJ81858 ,
What if Parameter is way that you can achive this.
You can refer to these link :-
https://ramvudugula9.medium.com/creating-user-input-variables-in-a-power-bi-report-9275b8b9f78d
https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-what-if
You can sync the what if parameter for every page . In Power BI Desktop you can synchronize slicers across multiple report pages. To synchronize slicers, in the View pane in the ribbon, select Sync slicers. When you synchronize slicers, the Sync Slicers pane appears, as shown in the following image.
Thanks,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
pratyashasamal When I create my What-If Parameter, I also create a measure to combine all of them, as my final value will always be bigger than 100,000, and doing this in intervals of 1 causes problems for my data.
I created 7 different What-If Parameters all with ranges from 0 to 9, so I am covered in any value from 0 to 9,999,999, and then my measure to combine them is:
Final Value = FORMAT((SELECTEDVALUE('Million'[Million])*1000000) + (SELECTEDVALUE('Hundred Thousands'[Hundred Thousands])*100000) + (SELECTEDVALUE('Ten Thousands'[Ten Thousands])*10000) +(SELECTEDVALUE('Thousands'[Thousands])*1000) + (SELECTEDVALUE('Hundreds'[Hundreds])*100) + (SELECTEDVALUE('Tens'[Tens])*10) + (SELECTEDVALUE('Ones'[Ones])), "Currency")This measure is being invoked on Calculated Columns, and even when I copy my slicers to the report pages, it gives me the following error even though the measure works on the given page:
Hi NJ81858 ,
Try to check if all the what if Parameter are having the correct data type i.e. Numeric data type.
Looks like issue is due to this.
Thanks,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
