Forum Discussion
Slicer / Button Assistance
Im new to PowerBI and need some assistance. I am trying to create a few buttons that would slice my data. For example, I have a "Last Activity" date in my data and need to create a few slicers that would be greater than 1 month, greater than 2 months, greater than 3 months, etc.
Thanks in advance for any assistance!
4 Replies
It would be very helpful if you provide a sample of your data (false if confidential of course) and what your expected outcome is (Sum of sales? Sum of activity....?).
Some outcomes can actually be obtained using the default date slicer/filter pane; for other things you need to create specific measures and use buttons/bookmarks to change visualisations etc.I am trying to reduce the number of liceses we use at work. Therefore, am looking for a quick easy way to display the total number of "Active_Status" with a "Last_Logon_Date greater than >9, >6, >3 months. Ideally, I would be able to click a slicer to see the number display in a card.
Further, I would like to see the data displayed in the table, example would be users not logged in in >9, >6, >3 months and display a number below.
Here's an example of the data
A couple of things...
1) can you please include the user id in the sample data? At the moment you can only calculate Account_status and/or Identity_status, but there is no way of knowing how many users the sample data refers to.
2) do you want the period to be static (>3, >6 or > 9) or variable (select any time frame)?
3) you mention Active_status. Is that a different column not included in the sample data or which column does it refer to?
