Forum Discussion

Ibrahim_shaik's avatar
Ibrahim_shaik
Icon for Helper V rankHelper V
3 years ago

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.   ...
Need Help
Show and Tell
Ibrahim_shaik's avatar
Ibrahim_shaik
Icon for Helper V rankHelper V
3 years ago

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's avatar
Adamboer
Icon for Responsive Resident rankResponsive Resident
3 years ago

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.