Is there anyway to draw line in line chart that shows the trend only up to selected point in time?

[Ajaal]

In may case I have two visuals 1-card visual that shows the value for each selected month for a category 2- a line chart both are one page. I want that line chart to draw the trend of values up to filterd value. so when I filter my page by date I shoud see the cared visual shows the value of that selected month and the line chart show the trend up the selected date, line starts from lowest date up the selected date (filterd date)..Is that possible to be achived??

[AnalyticsWizard · Accepted solution]

@Ajaal 

1. Add a card visual for the month's value.
2. Create a line chart with date on the axis and the value as the line.
3. Use a date slicer to select the month.
4. Under 'Edit interactions', set the line chart to listen to the slicer and other visuals to ignore it.

When you select a date in the slicer, the card shows data for that month, and the line chart shows the trend from the beginning up to the selected month.

If you find this helpful, feel free to mark it as a solution, and any kudos are much appreciated!

[AnalyticsWizard · Accepted solution]

@Ajaal 

1. Add a card visual for the month's value.
2. Create a line chart with date on the axis and the value as the line.
3. Use a date slicer to select the month.
4. Under 'Edit interactions', set the line chart to listen to the slicer and other visuals to ignore it.

When you select a date in the slicer, the card shows data for that month, and the line chart shows the trend from the beginning up to the selected month.

If you find this helpful, feel free to mark it as a solution, and any kudos are much appreciated!

[Ajaal]

sorry..but where to find (Edit interactions) option..???

[v-binbinyu-msft · Accepted solution]

Hi @Ajaal ,

First of all, many thanks to @AnalyticsWizard and @tharunkumarRTK  for your very quick and effective replies.

When you select a visual then click Format, you will find the Edit interaction options

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[tharunkumarRTK]

@Ajaal 

It is possible, follow the dax pattern explained here: https://community.fabric.microsoft.com/t5/Desktop/Need-help-on-setting-date-filter-for-plan-and-actu...

If the post helps please give a thumbs up

If it solves your issue, please accept it as the solution to help the other members find it more quickly.

Tharun