Display the selected month in the slice for all years of my dataset.

[Anonymous]

Hi community,

I'm having the following case:

For example, in a date Slicer, I select the period 10/01/2019 - 10/31/2019 (October). Then, I need to display a bar chart with same
month selected (October) for all years of my dataset.

The Slicer need be a slider format.

[Fowmy]

@Anonymous 

You need to make a copy of your dates table, Say if your date table is Dates and the Copy Dates2. Create the following Measure

All Year Month= 

VAR _Date1SelectedMonth = MONTH(MAX(Dates[Date]))
var _Date2Selected = MAX(Dates2[Date])

Return

IF(
    MONTH( _Date2Selected ) = _Date1SelectedMonth , 
    [Measure to Apply]
)

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[Anonymous]

Hi, the solution It didn't work for the year, the values ​​appear only when I'm in the context of the month. Which turns out to be a problem when I have more than one month selected, as I need a single bar with the sum of the selected period for each year.

[Fowmy]

@Anonymous 

I have added a month column to the DATES table and modified the formula.

All Year Month = 

VAR _Months = VALUES(Dates[Month]) Return

IF( MONTH(MAX(Dates2[Date])) in _Months, 1, 0)

 
I have selected Mar Apr and Jun in 2018 the table visual shows the same months for all three years.

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[Anonymous]

Example:
I have this data set:

Year	Month	Total
2018	jan	50
2018	fev	22
2018	mar	11
2018	abr	16
2018	mai	23
2018	jun	32
2018	jul	25
2018	ago	11
2018	set	554
2018	out	5
2018	nov	10
2018	dez	15
2019	jan	12
2019	fev	21
2019	mar	19
2019	abr	27
2019	mai	226
2019	jun	222
2019	jul	33
2019	ago	24
2019	set	99
2019	out	10
2019	nov	10
2019	dez	20

I need that visualization.