MTD YTD Filter without redefining measures

[ThreeBlindMice]

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?

[v-shex-msft · Accepted solution]

Hi @ThreeBlindMice ,

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

[ThreeBlindMice]

Hi

Thanks for that suggestion.

I've rebuilt my date table to be more dynamic (so that it outputs columns of 'MTD' and 'YTD') and the unpivot within PBI. An attribute table and a couple of links and it seems to work.

Now just have to check the results.

[amitchandak]

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-wi...
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p...
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

[amitchandak]

Also Refer https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...