How to Filter the Line Chart with the Relative Time Slicer

[Ibrahim_shaik]

Hello Power BI Community,

I want to filter the line chart with respect to time.

When I try to filter the line chart with time the line chart is not filtering.

Please give a solution.

Thanks&Regards,

Ibrahim.

[Ibrahim_shaik]

Hello Power BI Community,

I want to filter the line chart with respect to time.

When I try to filter the line chart with time the line chart is not filtering.

Please give a solution.

Thanks&Regards,

Ibrahim.

[ichavarria]

Hi @Ibrahim_shaik,

To filter a line chart with respect to time in Power BI, you need to make sure that the time field is set up correctly and is recognized as a date/time data type in Power BI.

Once you have confirmed that the time field is correctly recognized as a date/time data type, you can proceed with filtering the line chart as follows:

1. Click on the line chart to select it.
2. In the Visualizations pane, click on the Filters icon.
3. Click on the Add filter button and select the time field you want to filter by.
4. Choose the type of filter you want to apply (e.g. between, before, after, etc.) and set the appropriate date/time range.
5. Click Apply filter to apply the filter to the line chart.

If the line chart is still not filtering after following these steps, it could be due to other factors such as data formatting issues or incorrect filter settings. You may need to review your data and filter settings to identify and resolve any issues.

Best regards, 

Isaac Chavarria

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

[Mort1r]

nice!

[Ibrahim_shaik]

Hello Power BI Community,

I want to filter the line chart with respect to time.

When I try to filter the line chart with time the line chart is not filtering.

Please give a solution.

Thanks&Regards,

Ibrahim.

[Adamboer]

To filter a line chart in Power BI, you need to ensure that the data type of the time column is set to 'Date' or 'DateTime'. Once you have done that, you can use the time column as an axis and apply a filter to the line chart.

To filter the line chart based on time, you can add a slicer to the report and select the time period you want to filter on. You can also use the filter pane to select the time period.

If the line chart is not filtering, you may need to check the data type of the time column and ensure that it is set correctly. You can also try using the 'Relative Date Slicer' visual to filter the line chart based on time.

[Greg_Deckler]

@Ibrahim_shaik Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[amitchandak]

@Ibrahim_shaik , hope the filter is connected date.

can you share the some screenshots

[Ibrahim_shaik]

Hi @amitchandak ,

Please Check and let me know the solution.