Forum Discussion
How to Filter the Line Chart with the Relative Time Slicer
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.
- Greg_Deckler3 years ago
Community Champion
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. - Adamboer3 years ago
Responsive Resident
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.