Forum Discussion

vickyprudhvi's avatar
vickyprudhvi
Icon for Helper IV rankHelper IV
10 years ago

Parameter Text box

Hi, I am not sure if it is possible or there is a round about way. I am looking for suggestions. I want to create a parameter text box kind interface where user can enter the value such as target or...
Need Help
konstantinos's avatar
konstantinos
Icon for Memorable Member rankMemorable Member
10 years ago

There is no easy, convinient way of doing it specially in the service.

There are some workarounds but depends which client tool users access the data.

 

For the PowerBI service this post from Chris Webb is really cool - http://blog.crossjoin.co.uk/2015/11/24/using-parameter-tables-to-control-data-refresh-in-power-bi/

 

For excel I wrote something similar with macros & linked tables

https://medium.com/@Konstantinos_Ioannou/power-pivot-change-measures-with-disconnected-cells-4066ee55befc#.235dtxuzy

 

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi,

 

5 years after, I want to know if there is a better way to do this and to add some 'parameter' or variables in a text box, something more dynamic ?

 

Thank you,

Loveboch