SSRS Line Chart Same Date on x-axis

I build a line chart wherein x-axis need to show only start date and end date while removing the middle dates. So I have achieved that by the scalar expression.

=datediff("d",first(Fields!Date.Value),last(Fields!Date.Value))

However, when the start date and end date is the same for eg: 11-20-2018 then the x-axis shows 11-20-2018 multiple times and 11-21-2018(which is not an end date) where i need to show it only once. Please suggest how to achieve.

This is what is required

edited Nov 20 '18 at 18:34

James Z

11.1k71835

asked Nov 19 '18 at 19:46

ashishsingh92

751115

1

I don't see much difference in your pictures. Am I just blind?
– James Z
Nov 19 '18 at 19:56

Possible duplicate of stackoverflow.com/questions/40591370/…
– Strawberryshrub
Nov 20 '18 at 7:49

@JamesZ question edited. There was a duplicate image attached. Apologize for that.
– ashishsingh92
Nov 20 '18 at 11:54

@Strawberryshrub this is not what im exactly looking for!
– ashishsingh92
Nov 20 '18 at 12:00

Does it help when you go to your Horizontal Axis Properties and set the intervall to 1?
– Strawberryshrub
Nov 20 '18 at 12:42

|
show 2 more comments

I build a line chart wherein x-axis need to show only start date and end date while removing the middle dates. So I have achieved that by the scalar expression.

=datediff("d",first(Fields!Date.Value),last(Fields!Date.Value))

This is what is required

edited Nov 20 '18 at 18:34

James Z

11.1k71835

asked Nov 19 '18 at 19:46

ashishsingh92

751115

1

I don't see much difference in your pictures. Am I just blind?
– James Z
Nov 19 '18 at 19:56

Possible duplicate of stackoverflow.com/questions/40591370/…
– Strawberryshrub
Nov 20 '18 at 7:49

@JamesZ question edited. There was a duplicate image attached. Apologize for that.
– ashishsingh92
Nov 20 '18 at 11:54

@Strawberryshrub this is not what im exactly looking for!
– ashishsingh92
Nov 20 '18 at 12:00

Does it help when you go to your Horizontal Axis Properties and set the intervall to 1?
– Strawberryshrub
Nov 20 '18 at 12:42

|
show 2 more comments

I build a line chart wherein x-axis need to show only start date and end date while removing the middle dates. So I have achieved that by the scalar expression.

=datediff("d",first(Fields!Date.Value),last(Fields!Date.Value))

This is what is required

edited Nov 20 '18 at 18:34

James Z

11.1k71835

asked Nov 19 '18 at 19:46

ashishsingh92

751115

I build a line chart wherein x-axis need to show only start date and end date while removing the middle dates. So I have achieved that by the scalar expression.

=datediff("d",first(Fields!Date.Value),last(Fields!Date.Value))

This is what is required

reporting-services ssrs-2008

edited Nov 20 '18 at 18:34

James Z

11.1k71835

asked Nov 19 '18 at 19:46

ashishsingh92

751115

edited Nov 20 '18 at 18:34

James Z

11.1k71835

asked Nov 19 '18 at 19:46

ashishsingh92

751115

edited Nov 20 '18 at 18:34

James Z

11.1k71835

edited Nov 20 '18 at 18:34

James Z

11.1k71835

edited Nov 20 '18 at 18:34

James Z

11.1k71835

asked Nov 19 '18 at 19:46

ashishsingh92

751115

asked Nov 19 '18 at 19:46

ashishsingh92

751115

asked Nov 19 '18 at 19:46

ashishsingh92

751115

1

I don't see much difference in your pictures. Am I just blind?
– James Z
Nov 19 '18 at 19:56

Possible duplicate of stackoverflow.com/questions/40591370/…
– Strawberryshrub
Nov 20 '18 at 7:49

@JamesZ question edited. There was a duplicate image attached. Apologize for that.
– ashishsingh92
Nov 20 '18 at 11:54

@Strawberryshrub this is not what im exactly looking for!
– ashishsingh92
Nov 20 '18 at 12:00

Does it help when you go to your Horizontal Axis Properties and set the intervall to 1?
– Strawberryshrub
Nov 20 '18 at 12:42

|
show 2 more comments

1

I don't see much difference in your pictures. Am I just blind?
– James Z
Nov 19 '18 at 19:56

Possible duplicate of stackoverflow.com/questions/40591370/…
– Strawberryshrub
Nov 20 '18 at 7:49

@JamesZ question edited. There was a duplicate image attached. Apologize for that.
– ashishsingh92
Nov 20 '18 at 11:54

@Strawberryshrub this is not what im exactly looking for!
– ashishsingh92
Nov 20 '18 at 12:00

Does it help when you go to your Horizontal Axis Properties and set the intervall to 1?
– Strawberryshrub
Nov 20 '18 at 12:42

I don't see much difference in your pictures. Am I just blind?
– James Z
Nov 19 '18 at 19:56

Possible duplicate of stackoverflow.com/questions/40591370/…
– Strawberryshrub
Nov 20 '18 at 7:49

@JamesZ question edited. There was a duplicate image attached. Apologize for that.
– ashishsingh92
Nov 20 '18 at 11:54

@Strawberryshrub this is not what im exactly looking for!
– ashishsingh92
Nov 20 '18 at 12:00

Does it help when you go to your Horizontal Axis Properties and set the intervall to 1?
– Strawberryshrub
Nov 20 '18 at 12:42

|
show 2 more comments

1 Answer
1

active

oldest

votes

I think there are two ways what you can do.

First one would be to use just one parameter (with the option to allow multiple values). So just the dates you chose from the parameter would appear in the chart.

Second one would be to use a filter in your chart. Go to your Chart Properties > Filters and add the following filter:

'Expression

=IIF(CDate(Fields!YourDate.Value) = CDate(Parameters!YourFirstDate.Value) Or CDate(Fields!YourDate.Value) = CDate(Parameters!YourSecondDate.Value), True, False)



'Format

=Boolean



'Value

=True

answered Nov 21 '18 at 5:41

Strawberryshrub

1,1601216

didn't work for both suggestion!
– ashishsingh92
Nov 27 '18 at 14:07

add a comment |

Your Answer

StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});

}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53381628%2fssrs-line-chart-same-date-on-x-axis%23new-answer', 'question_page');
}
);

Post as a guest

Name

Required, but never shown

1 Answer
1

active

oldest

votes

1 Answer
1

active

oldest

votes

I think there are two ways what you can do.

First one would be to use just one parameter (with the option to allow multiple values). So just the dates you chose from the parameter would appear in the chart.

Second one would be to use a filter in your chart. Go to your Chart Properties > Filters and add the following filter:

'Expression

=IIF(CDate(Fields!YourDate.Value) = CDate(Parameters!YourFirstDate.Value) Or CDate(Fields!YourDate.Value) = CDate(Parameters!YourSecondDate.Value), True, False)



'Format

=Boolean



'Value

=True

answered Nov 21 '18 at 5:41

Strawberryshrub

1,1601216

didn't work for both suggestion!
– ashishsingh92
Nov 27 '18 at 14:07

add a comment |

I think there are two ways what you can do.

First one would be to use just one parameter (with the option to allow multiple values). So just the dates you chose from the parameter would appear in the chart.

Second one would be to use a filter in your chart. Go to your Chart Properties > Filters and add the following filter:

'Expression

=IIF(CDate(Fields!YourDate.Value) = CDate(Parameters!YourFirstDate.Value) Or CDate(Fields!YourDate.Value) = CDate(Parameters!YourSecondDate.Value), True, False)



'Format

=Boolean



'Value

=True

answered Nov 21 '18 at 5:41

Strawberryshrub

1,1601216

didn't work for both suggestion!
– ashishsingh92
Nov 27 '18 at 14:07

add a comment |

I think there are two ways what you can do.

First one would be to use just one parameter (with the option to allow multiple values). So just the dates you chose from the parameter would appear in the chart.

Second one would be to use a filter in your chart. Go to your Chart Properties > Filters and add the following filter:

'Expression

=IIF(CDate(Fields!YourDate.Value) = CDate(Parameters!YourFirstDate.Value) Or CDate(Fields!YourDate.Value) = CDate(Parameters!YourSecondDate.Value), True, False)



'Format

=Boolean



'Value

=True

answered Nov 21 '18 at 5:41

Strawberryshrub

1,1601216

I think there are two ways what you can do.

First one would be to use just one parameter (with the option to allow multiple values). So just the dates you chose from the parameter would appear in the chart.

Second one would be to use a filter in your chart. Go to your Chart Properties > Filters and add the following filter:

'Expression

=IIF(CDate(Fields!YourDate.Value) = CDate(Parameters!YourFirstDate.Value) Or CDate(Fields!YourDate.Value) = CDate(Parameters!YourSecondDate.Value), True, False)



'Format

=Boolean



'Value

=True

answered Nov 21 '18 at 5:41

Strawberryshrub

1,1601216

answered Nov 21 '18 at 5:41

Strawberryshrub

1,1601216

answered Nov 21 '18 at 5:41

Strawberryshrub

1,1601216

answered Nov 21 '18 at 5:41

Strawberryshrub

1,1601216

didn't work for both suggestion!
– ashishsingh92
Nov 27 '18 at 14:07

add a comment |

didn't work for both suggestion!
– ashishsingh92
Nov 27 '18 at 14:07

didn't work for both suggestion!
– ashishsingh92
Nov 27 '18 at 14:07

add a comment |

draft saved

draft discarded

Thanks for contributing an answer to Stack Overflow!

Please be sure to answer the question. Provide details and share your research!

But avoid …

Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

Some of your past answers have not been well-received, and you're in danger of being blocked from answering.

Please pay close attention to the following guidance:

Please be sure to answer the question. Provide details and share your research!

But avoid …

Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

Search This Blog

Ufyukyu