Creation of an interactive table recommendation

[Anonymous]

Dear all.

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?

Hope you can help me.

Thanks!!

[zoloturu]

Hi @Anonymous,

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.

See good examples:

http://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive

https://docs.microsoft.com/en-us/power-bi/desktop-bookmarks

Regards,
Ruslan
-------------------------------------------------------------------
Did I answer your question? Mark my post as a solution!