cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
MarinaE
Frequent Visitor

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

Accepted Solutions
Super User IV
Super User IV

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

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)

---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

View solution in original post

3 REPLIES 3
Super User IV
Super User IV

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

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)

---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

View solution in original post

MarinaE
Frequent Visitor

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

That worked perfectly! THANK YOU!!!!

Super User IV
Super User IV

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

Great! 🙂

---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors