Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Syndicate_Admin
Administrator
Administrator

Date segmentation

Hello

I have the following segmentation filters and a curious thing happens to me, if I filter for the year 2023 (I have data), the next month filter no longer appears the January option. Do you know why?

apenaranda_0-1675239969576.png

I would like it to come out because I do the VentasLY month by month,

If the date filter is of this type as the capture, they come out well but in the other way VLY counts me of all 2022 and not only of January 2022, I imagine that by not selecting the month it does not do the right thing.

apenaranda_1-1675239969577.png

Thanks a lot.

1 REPLY 1
Anonymous
Not applicable

Hi @Syndicate_Admin 

Did you create a date table, if you use the date in a date table, after testing, it has no problem when put a data field to the slicer, when you choose a year, it wll also display all months

vxinruzhumsft_0-1677045123925.png

 

Best Regards!

Yolo Zhu

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

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors