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
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:
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.
Solved! Go to Solution.
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.
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.
User | Count |
---|---|
120 | |
95 | |
88 | |
73 | |
66 |
User | Count |
---|---|
138 | |
112 | |
110 | |
98 | |
94 |