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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
koorosh
Post Partisan
Post Partisan

monthly chart over between date slicer

Hello Experts, when I use between date slice, I want to have all months inside between date slicer in the month axis. For the attached file, have individual value for Nov 2018 till Oct 2022 month by month .

 

Regards

 

https://drive.google.com/file/d/1jwefyB_F6yzERvGUPxfu86QggfBUtbeo/view?usp=sharing

 

1 ACCEPTED SOLUTION
ALLUREAN
Solution Sage
Solution Sage

Hi, @koorosh 

Check this example:

https://www.dropbox.com/s/n8pug4qz7x7xg16/Test3_onedrive%28allure-analytics.com%29.pbix?dl=0

 

You shoud use year also in your x-axis, not only month in order to get all dates. I've created a simple hierarhy (year-month-day) and use in X-Axis. If you want, you can enable auto-time intelligence and use date hierarchy at the same way.

 

Did I answer your question? Please Like and Mark my post as a solution if it solves your issue. Thanks.

Appreciate your Kudos !!!

https://allure-analytics.com/

https://www.youtube.com/channel/UCndD_QZVNB_JWYLEmP6KrpA

https://www.linkedin.com/company/77757292/

 

 




Did I answer your question? Mark my post as a solution!


https://allure-analytics.com/
https://www.youtube.com/channel/UCndD_QZVNB_JWYLEmP6KrpA
https://www.linkedin.com/company/77757292/

Proud to be a Super User!




View solution in original post

6 REPLIES 6
serpiva64
Super User
Super User

Hi,

if this is what you need i think the easiest way is to create a calculated column:

YearMonth = Date_Dim[Year]&"-"&Date_Dim[Month]
and use it in axis X
serpiva64_0-1644060629807.png

 

If this post isuseful to help you to solve your issue consider giving the post a thumbs up and accepting it as a solution !

ALLUREAN
Solution Sage
Solution Sage

Hi, @koorosh 

Check this example:

https://www.dropbox.com/s/n8pug4qz7x7xg16/Test3_onedrive%28allure-analytics.com%29.pbix?dl=0

 

You shoud use year also in your x-axis, not only month in order to get all dates. I've created a simple hierarhy (year-month-day) and use in X-Axis. If you want, you can enable auto-time intelligence and use date hierarchy at the same way.

 

Did I answer your question? Please Like and Mark my post as a solution if it solves your issue. Thanks.

Appreciate your Kudos !!!

https://allure-analytics.com/

https://www.youtube.com/channel/UCndD_QZVNB_JWYLEmP6KrpA

https://www.linkedin.com/company/77757292/

 

 




Did I answer your question? Mark my post as a solution!


https://allure-analytics.com/
https://www.youtube.com/channel/UCndD_QZVNB_JWYLEmP6KrpA
https://www.linkedin.com/company/77757292/

Proud to be a Super User!




How you did X-axis label as below ?

koorosh_0-1644061755204.png

My X-Axis label can not align vertically and like yours?

koorosh_1-1644061860608.png

 

concatenate.png




Did I answer your question? Mark my post as a solution!


https://allure-analytics.com/
https://www.youtube.com/channel/UCndD_QZVNB_JWYLEmP6KrpA
https://www.linkedin.com/company/77757292/

Proud to be a Super User!




serpiva64
Super User
Super User

Hi,

i'm not able to open it.

Please try again.

 

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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