Forum Discussion
Dynamically changing measures with in a line chart
Hey thanks for the responce,
the problem with this is the same as the switch i already tried, with out multi selecting the slicer you can't put multiple measures onto the chart and all though that may seem easy enough for IT people unfortuantly that doesnt meet the business specs required.
What i ended up doing is kind of a workaround with bookmarks and putting different chart on different pages that all look the same so it appears like our clicking a button and only the chart is changing as far as the user is concerned.
Resident RockstarHi,
here is a strategy that migh work for you:
-Create a new table with only the name of your measures(does not have to be the name of the measure, but might be easier for your users). So table name = SelectMeasures, and name of the column = Measure.
-Create a new measure like this:
select measure =
SWITCH (
TRUE ();
SELECTEDVALUE ( SelectMeasures[Measure] ) = [your measure name 1];
SELECTEDVALUE ( SelectMeasures[Measure] ) = [your measure name 2];
.
.
.
.
.
BLANK ()
)
-Add the Measure-column in the legend field of a line chart.
-Add the measure [select measure] as value of the line chart.
-Add year/date to axis of the line chart.
-Create a slicer of the Measure-column.
Hey thanks for the responce,
the problem with this is the same as the switch i already tried, with out multi selecting the slicer you can't put multiple measures onto the chart and all though that may seem easy enough for IT people unfortuantly that doesnt meet the business specs required.
What i ended up doing is kind of a workaround with bookmarks and putting different chart on different pages that all look the same so it appears like our clicking a button and only the chart is changing as far as the user is concerned.
- sturlaws
so what you want to do is show measures on groups of CY,PY and Targets?
Yeah, so i need show the metric as whole which consists of those 3 measures as shown above
- sturlaws
ah, my bad, I should have understood that from you first post.
But if you use the strategy I suggested, and add new column, call it MeasureGroup, so the measures CY1, PY1 and T1 is group 1 and so on. Use this new column as values for a slicer. Perhaps check out the ChicletSlicer from Marketplace, which will give you more of a button-feel(just remember to turn off Multiple selection)