virosu on 10 Mar 2016 17:26:36
Dynamic filters: give the ability to select Visual/Page/Report advanced filters based on relationships between fields
- Comments (2)
RE: Dynamic filters
Yes please! For example, the ability to filter a report/page by year where the calculation for that comes from the Power Query module loaded into the data model as a value. I do this inside of Power Query all of the time. I'd love to be able to type in MaxYear into the filter section instead of having to hard code to a number then hoping I remember to change it in January.
RE: Dynamic filters
For example, when calculating DAU/MAU/Freq. DAU and MAU come from the table. Freq is a measure equal to DAU/MAU. I want to filter the data by Freq but am unable to. Freq would tell me which slice of customers is more engaged.
DAU = Daily Active Users (Avg of unique users over the last 28 days)
MAU = Monthly Active Users (Unique users over the last 28 days)
Freq = DAU/MAU (A measure of engagement)