Solved: Input external data easily to create reports

Anonymous · ‎07-01-2019

Hi All,

I'm trying to build a dashboard to monitor sales. This dashboard should be a tool for users to follow some KPIs.

One of the KPIs is Sales, but each of the user can decide the price of the product he sells.

Basically, I would like to allow users to input the price they fix for each product then use the input as a table.

I know it may not be what PowerBI is for, but is there any smart way to do this?

Thanks,

A.

v-yuta-msft · ‎07-02-2019

@Anonymous ,

So you want the sales be changed dynamically by user input, right? Generally, I think the "What-if" parameter may meet your requirement, for more details please refer to:

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

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

v-yuta-msft · ‎07-16-2019

@Anonymous ,

Have you solved your issue by now? If you have, could you please help mark the correct answer to finish the thread? Your contribution will be much appreciated.

Regards,

Jimmy Tao

v-yuta-msft · ‎07-02-2019

@Anonymous ,

So you want the sales be changed dynamically by user input, right? Generally, I think the "What-if" parameter may meet your requirement, for more details please refer to:

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

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.