Accessing Constant values from another table which should reflect in visualization.

[Anonymous]

HI Team,

I'm planning to make a constant table which would contain all consolidated  values of all tables in one specific table. From where if we change the value in this constant table it has to change the visualizations related to that value. 

My question is, is it possible to do such so that no need to involve all the graphs to change the value only one specifc table can be managed. But I tried using "Lookupvalue" , "Related", "Managing Relations between tables" nothing could help me acheveing.

This is constant table I prepared by only taking the values.

 

These are the graphs which is mapped with another table with few measures.  

My Moto is if I change the value in that constant table it should reflect in these graphs.

Regards,

Haveesh

[lbendlin]

 if I change the value in that constant table it should reflect in these graphs

what's your definition of "constant"?

[Anonymous]

The Value.

For example: No of IP's which are less than equal to 19. so i'll give the value 19 in that table separately. if later i need to change the value i'll be just changing in that seperate table and it should reflect accordingly.

[lbendlin]

How are you planning to " change that later"?

[Anonymous]

Just going to power query and change the vlue alone manually, so that it would reflect 

[lbendlin]

That approach would not work once your report is published to the Power BI service. Consider using parameters instead.

[Anonymous]

I need to and will be chaning only in the desktop application not in the service. Once set a value and deploying in service is all I need. and if at all needed to change I would be doing through desktop application only. 

For which I need guidance how to get that achieved and also do suggest on how to do with parameters as well.