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
MojoGene
Post Patron
Post Patron

Constant Line on x-Axis Contingent on Selection?

I would like to show constant lines along the x-axis on this line chart for each transition from one day to the next. I can accomplish this simply by entering a hard date value for each line, but I would like the constant line to be in the visual only if the date/time is selected. With hard values, the visual looks like this:

 

MojoGene_0-1699448808904.png

Because the selection does not include the last 2 days, the visual shows empty fields.

 

I have struggled for a while with the ISINSCOPE function to see if I could create a measure that would show the constant line only when the date is within the selection, but I have hit the wall. Any advice appreciated.

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @MojoGene ,

Please have a try.

Constant Line = 
IF(
    ISINSCOPE('Table'[Date]),
    [Value of Constant Line],
    BLANK()
)

 

How to Get Your Question Answered Quickly 

 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

 

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

 

 

 

View solution in original post

1 REPLY 1
Anonymous
Not applicable

Hi @MojoGene ,

Please have a try.

Constant Line = 
IF(
    ISINSCOPE('Table'[Date]),
    [Value of Constant Line],
    BLANK()
)

 

How to Get Your Question Answered Quickly 

 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

 

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

 

 

 

Helpful resources

Announcements
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.