cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## The sales plan on the card is not displayed if the slice is not set on the first day of the month.

I have a standard sales plan table. The date column displays only the first days of each of the 12 months. I display the budget amount on a card and create a slice by the date column, which is formed as DateTable = CALENDARAUTO(12).
When I specify a time interval in the slice that includes the first of the month, I get the budget amount. As soon as I set an intermediate date, for example 01/02/2023 - 01/20/2023, the budget data disappears. It is necessary for me, that the budget of month or months falling in the interval of time chosen by me was deduced.
I will be grateful for your help!

3 REPLIES 3
Community Support

Hi  @Sergii22 ,

I created some data:

Here are the steps you can follow：

1. Create calculated table.

``````Date =
DISTINCT('Table'[Date])``````

2. Create measure.

``````Measure =
var _mindate=MINX(ALLSELECTED('Date'),[Date])
var _maxdate=MAXX(ALLSELECTED('Date'),[Date])
var _select=
SELECTCOLUMNS(
FILTER(ALL('Table'),'Table'[Date]>=_mindate&&'Table'[Date]<=_maxdate),"Month",MONTH('Table'[Date]))
return
SUMX(FILTER(ALL('Table'),
MONTH('Table'[Date]) in _select),[Value])``````

3. Result:

Best Regards,

Liu Yang

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

Frequent Visitor

Greetings! Thanks for the answer, but my problem is not solved.  I need the values to be displayed when selecting a range within the month as well. For example, if I select January 2 - January 20, the values will not be displayed on the card.

Super User

@Sergii22 , that depends on what measure you are using.

In case you use dates* or previous* functions

Why DATESMTD is still blank, even after having correct TI Setup: https://youtu.be/j0ug-XQgZtg

openingbalancemonth, openingbalancequarter, openingbalanceyear: https://youtu.be/6lzYOXI5wfo

Power BI Allocating Targets- closingbalancemonth, closingbalancequarter, closingbalanceyear:https://youtu.be/yPQ9UV37LOU

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors