Dynamic filter - Month Semestre

[Anonymous]

Hello,

I have two tables, Table date and Sales (and others but it's not the point).

The probleme is that I don't have the sales by date but only by semestre. (But I use other tables with dates)

So I would like that when I filter the date by "january" or 'april", the second (visual) filter "semestre" automatically changes to "Semestre 1".

Is it possible to do that in PBI ?

I'm currently doing that manually selecting the months of interest and selecting then Semestre 1 or 2...

Thanks

[v-stephen-msft · Accepted solution]

Hi @Anonymous ,

I made a simple sample you can refer to.

Create a calculated column and create a relationship between tables.

Semestre = SWITCH(TRUE(),[MonthNum] in {1,2,3,4},"Semestre 1",[MonthNum] in {5,6,7,8},"Semestre 2",[MonthNum] in {9,10,11,12},"Semestre 3")

Best Regards,

Stephen Tao

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

[amitchandak]

@Anonymous , Can you convert Semestre  to date

a new column like

switch(true() ,

[Semestre] ="Semestre  1" , date([year],1,1),

[Semestre] ="Semestre  2" , date([year],4,1),

[Semestre] ="Semestre  3" , date([year],7,1),

[Semestre] ="Semestre  4" , date([year],10,1)

)

I usually prefer to allocate. an example

Distributing/Allocating the Yearly Target(Convert to Daily Target): https://community.powerbi.com/t5/Community-Blog/Distributing-Allocating-the-Yearly-Target-Convert-to-Daily/ba-p/1463290