Forum Discussion

sonm10's avatar
sonm10
Helper I
4 years ago
Solved

Automatic slicer with Play axis

I have this unique requirement to show birthday and anniversary greetings in our Power BI which is being cast to a huge monitor. When we have multiple birthdays or anniversary the message should automatically scroll (or change) to other employees. The employee table contains employee ids, names, joining date and date of birth.

I refresh the data daily and have created a column to flag employees having anniversary or birthdays on that day. I then created a measure each for birthday and anniversary that adds greetings to the emplyee name which is then added to a card viusal.  I then added the birthday and anniversary flag to separate slicers and changed the "Edit Interaction" to ensure that the respective slicers only modify their card. When I change the slicer values, the card message is getting changed as desired.

Now to automate the looping of the greetings, I added the "play Axis" custom visual slicer which can change the slicer value automatically. When I keep only one slicer, its working as expected. However, when we add two play axis slicer, only one change while the other remains blank. I have changed the edit interactions also but is still not working.

As a demo, I have added a sample PBI file with similar requirement (Google Drive Link). I want the two slicers to work independently.

Any help is highly appreciated.

 

 

  • Hi, sonm10 ;

    I have reported the issue internally (ICM: 306656901). If there are any updates, I will post here, please be patient.


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

1 Reply

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Community Support

    Hi, sonm10 ;

    I have reported the issue internally (ICM: 306656901). If there are any updates, I will post here, please be patient.


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.