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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Line and clustered colum chart - start line at custom point on X-axis?

Hi!

I have a visualisation with has as column the monthly value of leavers rate for that month, then on the line I have the Rolling-12 for the same rate. My problem is that I dont have a full R12-value until January 2020, I would like the visualisation to show 12 month of monthly values but the R12-line to start at january 2020. 

 

I have thought and tried to change my measure, but the measure should have all the data, it is just the visualisation that should now show it. There is no way to filter just the line that I have found, then I filter the entire visualisation, which I dont want to. 

 

I can of course revert to having to different visualisations, one for 2019 without the line and one for 2020 with it but it will be visible and less dynamic. 

 

I was hoping for a smart solution to this problem 🙂 

 

Help? 

PBI problem.png

 

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

While not the recommended route, creating measures for specific visualizations, I would create another measure like:

Measure =
VAR __Date = MAX('Calendar'[Date])
VAR __Value = [Your Original Measure]
RETURN
IF(__Date < DATE(2020,1,1),BLANK(),__Value)

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

3 REPLIES 3
Greg_Deckler
Super User
Super User

While not the recommended route, creating measures for specific visualizations, I would create another measure like:

Measure =
VAR __Date = MAX('Calendar'[Date])
VAR __Value = [Your Original Measure]
RETURN
IF(__Date < DATE(2020,1,1),BLANK(),__Value)

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

That worked perfectly! THANK YOU!!!!

Great! 🙂

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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