How to make a Line Chart show data for dates in the chosen month?

[Anonymous]

Hi,

I have a dataset containing the number of active orders for a given date. I have a slicer to select a single date. I want to crate a line chart which shows the number of orders over time for all dates that are in the same month as the date selcted in the slicer.

I think a possible apporach would be:
1) Remove the interaction of the slicer on this visual
2) Create a measure which gives the order value for dates between EOMONTH(MAX('Data'[DATE]), -1) + 1 and MAX('Data'[DATE]) else BLANK()

3) Apply a filter on the visual for active orders must not be blank

The issue I'm having is that the measure doesn't seem to recognize my table or date column inside an IF statement. Am I missing something here? Is there a better way of doing this?

Thanks in advance!

[v-jianboli-msft · Accepted solution]

Hi @Anonymous ,

Based on your description, I have created  a simple sample:

Please try:

First create a new table for slicer:

Then create a measure:

Measure = SELECTCOLUMNS(FILTER('Table',MONTH([Date])=MONTH(SELECTEDVALUE('For slicer'[Date]))),"Orders",[Orders])

Add it to the Y axis field:

Final output:

Best Regards,

Jianbo Li

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

[Syk]

You shouldn't need a measure to do what I think your describing as a line chart with # of orders per month? If your date field is a heirarchy you can use the month value from there to get desired result.

If you can post an example of some of your data and perhaps an example of what you want, it should be a lot easier to help!

[RJuly2023]

Hi Syk,

I have the simmilar issue: I have an table with produced quantity every day on each line in each shift. I want to show for shift leaders from each shift thair performance, however started from beginning of the month by of selected day and not only this selected day.

I get one value for this day only.

Any idea?

regards

Robert

[RJuly2023]

Hi Syk,

I got it in the different way:

However, now, I didn't know how to show in visual only the choosen date.

Regards

Robert