Dynamic Target LIne Bar Chart

Hi  Anonymous ,

Question 2 is not very clear

According to your description, I create this data:

Here are the steps you can follow：

Create measure.
avg =
var _1=
MAX('Table'[Date])
return
AVERAGEX(
    FILTER(
        SUMMARIZE(ALLSELECTED('Table'),
        'Table'[Date],
        "Avg Value",AVERAGE('Table'[Point])),
        'Table'[Date]<=_1),
        [Avg Value])

How to create dynamic target line based on value from table:

You can use line and stacked column chart in visual object to display bar chart and line chart

How to show dynamic date based on filter：

1. Create measure.

Measure =
var _min=MIN('Table'[Date])
var _max=MAX('Table'[Date])
return _min&"-"&_max

2. Find the title and choose FX

3. Based on field select the created measure

4. Display the date filtered by slicer through title

You can downloaded PBIX file from here.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.