Timeframe Slicer using columns

[colinryan]

Hello,

I have columns containing the branches/departments and how many products were sold on different timeframes. And I want to be able to have a single select slicer on those timeframes so my charts and graphs would update depending on which timeframe I select. For example I want to see the top 10 branches/departments that sold the most products on 30 days or 180 days.

Thank you

[SamWiseOwl · Accepted solution]

Hi @colinryan 

Have you tried using the Parameter Fields?

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

[Anonymous · Accepted solution]

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

[SamWiseOwl · Accepted solution]

Hi @colinryan 

Have you tried using the Parameter Fields?

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