Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Dynamic Slicer to Filter Data

HI There, I am trying to create  a slicer/filter and chart like in excel  in which. I am having a datecolumn with TimeStamp and i want a view like below : Expected Result : TimePeriod ...
Need Help
Show and Tell
Tutorial Requests
TomasAndersson's avatar
TomasAndersson
Solution Sage
1 year ago

SELECTEDMEASURE() is a placeholder for a measure, any measure, that the calculation item will apply to. It is explained in the article i linked. So if you have [Sum if Sales] on the Y-axis and [Date] on the x-axis and choose 

Yesterday = 
CALCULATE(
    SELECTEDMEASURE(),
    Dates[Date] = TODAY() - 1
)

 Only yesterdays value for [Sum of Sales] will show in the visual, and so on.

 

The x-axis can't be controlled directly this way, but if you have hierarchy of some sort on the x-axis (e.g. Year / Month / Day / Hour) the user will be able to drill up or down as needed.

 

The alternative solution is to create several visuals and bookmarks and create buttons that hide/show the desired visual depending on your selection. But since you have so many time ranges you want to be able to slice by I think that approach will be too tedious. 

Anonymous's avatar
Anonymous
Not applicable
1 year ago

make sense tomas .

Let me try creating this way .

 

thanks,

ash

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Anonymous ,

    It's been a while since I heard back from you and I wanted to follow up. Have you had a chance to try the solutions that have been offered? If the issue has been resolved, can you mark the post as resolved? If you're still experiencing challenges, please feel free to let us know and we'll be happy to continue to help!
    Looking forward to your reply!

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Hi Anonymous ,

       

      This issue is still not resloved as my power bi doesnt have calculation group in ribbon. My pbi desktop is not updated as of now and it will take long to get this updated. So i am still stuck ..in this how can i create this.

      If you have any solution please let me know.

       

      Thanks,

      Ash