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
BIlix
Helper II
Helper II

Chart should show Values based on selected Year/Month

Hello Community,

I have a column Shart in my report with a measure in Values and Date in x Axis.
The values are Day-based.


When I select a whole year in my Date Slicer, the Visual should show the Monthly Values. 
When one or multiple months are selected, the Visual should show daily Values.

Thanks in Advance

1 REPLY 1
Jihwan_Kim
Super User
Super User

Hi, 

I am not sure how your datamodel looks like, but I tried to create a sample pbix file like below.

The below is one of many ways to achieve it.

Please check the below picture and the attached pbix file.

 

Jihwan_Kim_1-1692105128554.png

 

 

Jihwan_Kim_0-1692105113367.png

 

 


If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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