Forum Discussion
User Entered Value Across All Pages
Hello,
I have a report that is contingent on users entering in a value for all of my calculations. What is the best way to achieve this? It has to span multiple pages and I would prefer the user to only enter this once, as this value cannot be visible in the final report.
I have tried to create a What-If Parameter and added slicers to all pages and sync the slicer up across pages, but that has not worked for me. Thank you in advance!
6 Replies
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-9275b8b9f78dhttps://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 Cpratyashasamal 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
