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

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
giangnguyen
Frequent Visitor

Filter data Month

Currently my data from the planner excel, let me ask is currently available 3 buttons is Month, Week, Late how can I fillter the data. Thank you

 

datapbi.PNG

3 REPLIES 3
Anonymous
Not applicable

Hi @giangnguyen,

 

Instead of using buttons, drag the slicer from your visual and map the date columns to it. Then, go to properties and select whether you want multiselect or single select to filter the data based on a value.

 

Regards,

Pradeep

@Anonymous 

The date data is very much because I choose every day, I make a day button to select the aggregate data to appear only in the month

 

You can see an example on this page.https://app.powerbi.com/view?r=eyJrIjoiNDk1YWIwYTctOTlkOS00ZTRhLTk1NDAtYzdkYWZhZWM5OGFlIiwidCI6ImYwZmU1ZTA1LWJhM2YtNGFkYS05ZDFiLTg3ZDEyNzg4YWJkOCJ9

I really want the button to show data by month, week. If I do not choose, I default to the data.

@giangnguyen 

 

You may also try https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380786?src=office&tab=Overview.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors