Forum Discussion
Dynamic filter for year
Hi All,
I would like to show documents filtered for differing years dynamically.
So I would like to have a measure which only shows 2020 or 2022. How would I go about this.
Thanks in advance 🙂
Hi Stabbathehut
Do you add [date] column from a date table, then add"corresponding documents" to the same table visual?
If so, you could create a relationship between two tables.
For example, my date table is create as below:
date table = ADDCOLUMNS(CALENDAR(DATE(2020,1,1),DATE(2022,12,31)),"year",YEAR([Date]),"month",MONTH([Date])) add a calculated column firstdayperyear = CALCULATE(MIN('date table'[Date]),ALLEXCEPT('date table','date table'[year]))Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
8 Replies
measure=if(max(table[revision Date]) in {2020,2022},1,0)
Add it visual level filter ans set it to 1
Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar
If I resolve your problem Mark it as a solution and give kudos.check my blog here
https://community.powerbi.com/t5/Community-Blog/Connecting-to-a-Tabular-Model-Using-Power-BI/ba-p/913784Hi, thanks for the prompt response.
How would I have these as seperate measures for each 2020 and 2022?
Would like to show them in 2 instances
what measure are you expecting?
I will give one example of count.
measure1=Calculate(Count(Table[Column]),filter(table,Table[year]=2020))
measure2=Calculate(Count(Table[Column]),filter(table,Table[year]=2022))
Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar
If I resolve your problem Mark it as a solution and give kudos.check my blog here
https://community.powerbi.com/t5/Community-Blog/Connecting-to-a-Tabular-Model-Using-Power-BI/ba-p/913784
