Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Multiple segment switch over period for table values

Hello,

I have a table like above:

PeriodTeamCountryUsers countUsage count
2019-02ZAIT105
2019-03MPMUK32
2019-03TDCUS41
2019-04ZCFR83
2020-03............

 

I want to compute those results with two segments over YEAR and over QUARTER with a switch QUARTER TO MONTH like below.
With the Quarter switch active:

Witch the month switch active:

The selections have to modify the whole table values.

How can i perform it efficiently ?

segment
switch

1 Reply

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    5 years ago

    Hi, Anonymous 

    Please correct me if I wrongly understood your question.

     

     the first step is to create slicers: Year, Quarters, Months

     the second step is to create buttons: Quarter, Month -> by clicking one of those, it will hide or show the corresponding slicer.

     

    If you have a sample pbix file, please share and I can try to come up with desirable solution. 

     

    Thank you.

     

    Hi, My name is Jihwan Kim.

    If this post helps, then please consider accept it as the solution to help other members find it faster.