Timeframe Slicer using columns

Hi colinryan 

Have you tried using the Parameter Fields?

You can choose which fields or KPIs to show in your visual:

Hi,

Thanks for the soltion SamWiseOwl offered, and i want to offer some more information for user to refer to.

hello colinryan , you can also refer to the following solution.

Create a slicer table.

Then create a measure

MEASURE =
SWITCH (
    SELECTEDVALUE ( 'Slicer'[Choice] ),
    "30 Days", CALCULATE ( SUM ( 'Table'[Sold(30 Days)] ) ),
    "90 Days", CALCULATE ( SUM ( 'Table'[Sold(90 Days)] ) ),
    "180 Days", CALCULATE ( SUM ( 'Table'[Sold (180Days)] ) ),
    CALCULATE ( SUM ( 'Table'[Sold(365 Days)] ) )
)

Output

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly