Slicer to add a fixed value to a chart

[Chimsie]

Hello,

I'am looking for the possibility to add a slicer which add a fixed value to the cabinet in the chart, this fixed value is 50 kg or 100kg.
So for the first cabinet the value than will change from 300 to 350 and so on.

Or even better, a slicer to distribute 500kg (fix value) extra divided over the active cabinet.
The active cabinets can change through the existing filters

Is this possible via a filter?

[amitchandak · Accepted solution]

@Chimsie , You can add that line.

Use this as a line in clustered line visual or use in Y axis contact line under fx option

Use a what if parameter

measure = selectedvalue(whatif[Whatif])

or

measure = selectedvalue(whatif[Whatif])/ distinctcount(Table[Cabinate])

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

[Chimsie]

@amitchandak 

With the what if parameter I was able to creat a visualize variables😃

Dead load = SELECTEDVALUE(Cabinet[Weight]) + SUM ('Dead load'[Weigth])

This answered my first question, Is it also possible to create a slicer to distribute 500kg (fix value) divided over the active cabinet. (The active cabinets can change through the existing filters)

Current solution: