Forum Discussion

kurtrod's avatar
kurtrod
Frequent Visitor
3 years ago

Filter individual Columns using a slicer

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...
amitchandak's avatar
amitchandak
Super User
3 years ago

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

kurtrod's avatar
kurtrod
Frequent Visitor
3 years ago

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.