Forum Discussion
MTD YTD Filter without redefining measures
Hi
Looking for a way to apply a MTD or YTD filter to the entire page without having to rewrite all the measures (and many of these are nested
Have two columns in the DateTable with formulas for either MTD or YTD and want to use these to create a chiclet of MTD or YTD.
All the solution for this problem so far are diconnected tables with custom measures based on what is selected.
Ideas?
Hi Anonymous ,
I'd like to suggest you create a dynamic attribute filter or add a selector table as the source of the slicer, then you can use its selection and 'switch' function to change calculate results based on the slicer.
Dynamic Attributes In A Power BI Report
Power BI – Using a Slicer to show different measures
Regards,
Xiaoxin Sheng
4 Replies
Hi Anonymous ,
I'd like to suggest you create a dynamic attribute filter or add a selector table as the source of the slicer, then you can use its selection and 'switch' function to change calculate results based on the slicer.
Dynamic Attributes In A Power BI Report
Power BI – Using a Slicer to show different measures
Regards,
Xiaoxin Sheng
- amitchandak
Super User
Relative date filter filtering
https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range
You can have in slicer or in Page level parameter pane
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners/ba-p/890814
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p/881739
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
