topic Filter individual Columns using a slicer in DAX Commands and Tips

Filter individual Columns using a slicer

kurtrod — Mon, 23 Jan 2023 16:57:59 GMT

I am trying to create a slicer that will allow me to just pull back the data on a selected number of columns for time frame.

I.e. I want 4 timeframes (last week, last 4 weeks, last 13 weeks, last 52 weeks) to pull back the associated columns (one for sales $, sales qty, instock position, etc.)

Re: Filter individual Columns using a slicer

amitchandak — Mon, 23 Jan 2023 18:03:30 GMT

kurtrod , few way

https://community.powerbi.com/t5/Desktop/Required-custom-date-Slicer-Last-7-days-last-15-days-last-30/m-p/1284966#M561629

Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0

For week related formulas refer

Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123
https://www.youtube.com/watch?v=pnAesWxYgJ8

Time Intelligence, Part of learn Power BI https://youtu.be/cN8AO3_vmlY?t=27510
Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
Custom Period till date: https://youtu.be/aU2aKbnHuWs&t=145s

Re: Filter individual Columns using a slicer

kurtrod — Mon, 23 Jan 2023 18:53:01 GMT

I already have the time frames calculated within the separated columns. I just need a way to slice them to only pull back those associated columns.