Using the multiple values of a column to filter a line graphic.

[Anonymous]

Hi guys,

I need to plot a line graph with values until june and after june.

The thing is, in June i have a crucial parameter that could change. My user need to be able to single select this parameter for before june and after june, and my graphic have to plot both curves.

I was able to split my curve in 2 measures and works fine. But I can't use dynamic filters on it and still plot the same graph.

When my parameter is equal on both filters, no problem, but if I choose different numbers my visuals return nothing.

Any thoughts?

Thanks,

[Anonymous]

Hi @Anonymous ,

Perhaps you could try using the filed parameter, for which you can refer to the:Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Learn

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

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

[amitchandak]

@Anonymous ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

Refer a approach like this can help

How to get a single continuous line for Actual and Target without any break: https://youtu.be/41yhZz2pNTI
Appreciate your Kudos.

[Anonymous · Accepted solution]

Hi guys,

I managed to adapt this Solved: Same column, multiple filters - Microsoft Fabric Community solution to my problem and worked fine, creating different tables for each slicer.

@amitchandak(I'll take a look at the video you've sent either way to see if I can improve something on my model) and @Anonymous thanks for the support anyway.

Regards and thanks again.