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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
faisayed
Frequent Visitor

Future Months Showing In Bar Graph

Hi Team,

 

I have created a Date table with formula Reference Table = CALENDAR(DATE(2022,1,1),DATE(2023,1,31)) which gives me dates from 1st Jan 2022 till 31st Jan 2023.

However when I am uising this in bar graph with hierarchy Month and Year and selecting the option of "Show values with no data"

as I want to display previous months even if they dont have values its showing all the futhure months of 2023

(attached is the snapshot of the graph).

I want the same graph but the future months should not been seen.

If I make the table as Date table then its not giving option of adding hierarchy.

 

faisayed_0-1674196789829.png

 

 

1 ACCEPTED SOLUTION

Hi @faisayed ,
You can add column MonthYear Column in Reference Table that has Month+ Year .And then use that as a filter .
Thanks ,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C





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

Proud to be a Super User!





View solution in original post

5 REPLIES 5
faisayed
Frequent Visitor

Thank You @pratyashasamal I was able to resolve the issue with your sugestion.

Hi @faisayed ,
You are most welcome . Always happy to help .
Thanks ,
Pratyasha Samal





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

Proud to be a Super User!





faisayed
Frequent Visitor

@pratyashasamalThanks for your prompt response.

I have tried that but it still gives me the same issue and if I deselect the futur months it also removes the previous months as months are not categorized with years. For example I deselct Feb, it will deselect Feb for Previous year as well.

Hi @faisayed ,
You can add column MonthYear Column in Reference Table that has Month+ Year .And then use that as a filter .
Thanks ,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C





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

Proud to be a Super User!





pratyashasamal
Super User
Super User

Hi @faisayed ,
Please try to us CALENDERAUTO () function for this .
Please refer to this link :- https://learn.microsoft.com/en-us/dax/calendarauto-function-dax
If still the issue remains you can simply use filter and remove all the future months .
Thanks ,
Pratyasha Samal 
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C





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

Proud to be a Super User!





Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.