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
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi TomasAndersson ,

I will  try to create the same however what is "Selectedmeasure()" ?
Also i want to put my Today, yesterday, This week, last week and last 4 week weeks on X axis as well.

So for that what should i do ?

So let supopse if i selcteded Today() on Dynamic Slicer 

Vlaues should appear only in Hours on the chart X axis 
If i select last week then Days should appear on the chart X axis .

 

Is there anyway to create this as well?

 

Reagrds,

Ash

  • 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!