Data depends on highlight on line chart

Hi Anonymous ,

 

I create a simple example. Please check:

 

1. Create another table with your measure names by "Enter data".

 

2. Combine your multiple measures into one.

 

 

Measure =
SWITCH (
    SELECTEDVALUE ( MeasureName[MeasureName] ),
    "Sum Measure", [Sum Measure],
    "Avg Measure", [Avg Measure],
    [Sum Measure] // the default measure when nothing selected
)

 

 

 

3. Create a line chart.

 

4. Create a column chart and keep "Title" off.

 

5. Create a title measure and put it into a card visual, keep "Category" off, adjust font size.

 

 

Title = 
VAR Measure_ =
    SELECTEDVALUE ( MeasureName[MeasureName] )
RETURN
    IF ( ISBLANK ( Measure_ ), "Sum Measure by Date", Measure_ & " by Date" )

 

 

 

 

6. Group the card visual and the column visual.

(PS: I do this step because title function is not working with "Highlight" in this column chart based on my test.)

 

7. Test.

 

 

Best regards

Icey

 

If this post helps, then consider Accepting it as the solution to help other members find it faster.