My name is Andres and I work for a fertilizer company. Part of my job is to do fertilizer recomendation for farmers, and as you can guess, they vary a lot. I usually do an excel calculation and then a ppt slide with the recomendation (see example), but its a lot of work.
I'm trying to create an interactive table recommendation in Power BI, having the programm do the calculation (as in excel) and having a visual for the recomendation (as in ppt).
Do you have any idea how to create a recommendation table like this, that is interactive with slides and other things?
It is hard to recommend you a solution without an explanation of the detailed process from your side. It seems you need to do some calculations in DAX and/or M (Power Query). Then visualize your result using buttons and bookmarks.