I have report showing the energy in kWh used on streetlights. It includes a Bing map showing 20 lights. There is a graph showing the sum of kWh for all the lights the graph includes two “selected metrics” so you can compare actual energy used against a typical consumption kWH and a target saving.
The range of values in the typical consumption slicer should be dynamic by using the number of lights connected along with a MIN and MAX to give an appropriate range…
Lights energy range Min = ‘Key Measures Lighting’[Lights Connected] * 0.8 * 0.5
Lights energy range Max = ‘Key Measures Lighting’[Lights Connected] * 0.8 * 2
I then put these measures into the DAX to create a table ;
PowerBI all lights typical energy range = GENERATESERIES([Lights energy range Min],[Lights energy range Max],1) (so that as new lights get connected the slicer range grows accordingly)
This all seemed to work OK. Although I am not sure if the table will update in the future.
My employer wants the line graph and the slicer to interact with the map if one light only is selected.
I had hoped that as my typical energy range is based on measures the values would recalculate somehow but the original series remains unchanged.
Is there a way of having one slicer that changes its range upon selections?
Attached is a snip showing what happens to the line graph when one light is selected, thanks