Forum Discussion

colinryan's avatar
colinryan
Regular Visitor
2 years ago
Solved

Timeframe Slicer using columns

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

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • SamWiseOwl's avatar
    SamWiseOwl
    2 years ago

    Hi colinryan 

    Have you tried using the Parameter Fields?

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

     

  • Anonymous's avatar
    Anonymous
    2 years ago

    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

     

2 Replies

  • SamWiseOwl's avatar
    SamWiseOwl
    Super User
    2 years ago

    Hi colinryan 

    Have you tried using the Parameter Fields?

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

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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