Forum Discussion

Uhrond's avatar
Uhrond
Frequent Visitor
1 year ago
Solved

Help Needed with Time Axis Filtering in Power BI

Hello everyone,   I'm currently facing a challenge in Power BI and would appreciate your assistance. I have a time axis on a chart displaying data for the years 2024 and 2025. Additionally, I have...
Need Help
  • danextian's avatar
    danextian
    1 year ago

    Hi Uhrond 


    You'll need to use a disconnected table for the slicer and create another measure that references a column from that disconnected table. If you use a column from a related table, it will only return the rows that have been selected.

    Please see the attached sample pbix

Uhrond's avatar
Uhrond
Frequent Visitor
1 year ago

Thank you for your response. Unfortunately, even with MAX(), it does not work as I would like (I think it takes the MAX() of each date and therefore each year.) :

 

 

Sergii24's avatar
Sergii24
Super User
1 year ago

I agree with danextian, you'd need to go with disconnected date table.

Or simply add slicer on year instead of date 🙂