Forum Discussion
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 52 weeks) to pull back the associated columns (one for sales $, sales qty, instock position, etc.)
2 Replies
kurtrod , few way
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=pnAesWxYgJ8Time 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=145sI 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.
