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
Tobias106
Helper I
Helper I

Constant line on 2nd y-axis

Hello,

 

I have in my table a date colum. Also I have calender table.

 

I would like to integrate a constant line with the value 28 in my graph (stacked column with line).

 

In the analytics panel there is no option for a constant line.

 

I can create a simple measure like this: Measure = 28

 

BUT, then the line is hown from 2017 bis 2024. I only want the line between the date 01.01.2021 - 31.12.2022.

 

How can I solve this with a measure?

 

Thanks

 

Tobias

1 ACCEPTED SOLUTION
Rushki
Regular Visitor

Hi @Tobias106 ,
You can rewrite your measure as : 

Measure = IF( SELECTEDVALUE(Packing[Date]) >= DATE(2021,1,1) && SELECTEDVALUE( Packing[Date]) <= DATE(2022,12,31), 28, BLANK())

View solution in original post

2 REPLIES 2
Tobias106
Helper I
Helper I

Perfect @Rushki 😁

Rushki
Regular Visitor

Hi @Tobias106 ,
You can rewrite your measure as : 

Measure = IF( SELECTEDVALUE(Packing[Date]) >= DATE(2021,1,1) && SELECTEDVALUE( Packing[Date]) <= DATE(2022,12,31), 28, BLANK())

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.