Forum Discussion
Dynamic filter - Month Semestre
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
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.
2 Replies
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
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.
