cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BEN501
New Member

CALCULATE WITH DYNAMIC VALUES

Hello,

 

Iam looking to calculate salaries after bonuses have been allocated.

Bonuses must be defined by the final user in power BI.

For this, I generated a series of 0 to 20% that I want to assign to each employee and then use a slicer to define the bonus that I want to assign to each employee.

The slicer must only act on the line of the employee in question (how to do ? ).

once defined, the new salary including the bonus must be calculated automatically.

Looking forward to hearing from you!

THANK YOU !

BEN501_1-1670513031357.png

 

3 REPLIES 3
sturlaws
Super User
Super User

Hi, @BEN501,

 

If you have a small number of employees, it can be done in Power BI directly. For a larger number of employees, you would need to employ power apps. Either using just an power app, or embedd a power app in your power bi report.

It is unclear what you mean by final user. If you mean you are the only one allowed to adjust the slicers, while other users should see the same report, but not be able to use the slices, you would have to use object lever security. But it will not be pretty, the other users will get a box saying the visual is broken.

Cheers,
Sturla

If this post helps, then please consider Accepting it as the solution. Kudos are nice too.

@sturlaws Hey thank you for the reply!

would you please implement the solution using power automate in power BI that i can see how it works. You can do it for 2 or 3 persons and share the result with me please ?

 

The use case is: As an "HR manager" user, I must be able, from the BI report, to select/define the Bonus percentage for each employee and to see calculated automatically the new salary/employee integrating the bonus in order to be able to follow the budgetary bonus envelopes and payroll.

 

The case will cover 200 to 300 employee. So the solution has to be handled automatically via a function.

 

Thanks!

Ben

For that many users it is not doable, as you would have to create a slicer for each user, and it won't be dynamic

Helpful resources

Announcements
Join Arun Ulag at MPPC23

Join Arun Ulag at MPPC23

Get a sneak peek into this year's Power Platform Conference Keynote.

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors