Forum Discussion
Ranking items from multiple periods
you can try two things:
1. Create a calculated measure called Total Sales = Sum(Sales)
2. For ranking Measure use following expression:
Rank = RANKX(ALL(Table[ProductID],[Total Sales])
this will rank Each product for each month on basis of sales. You can use the new Rank measure in your visual filters and filter on topN. I think the calculated measures cannot be used as slicers so you have to use it as filter (Please someone correct me if I am wrong)
Regards
Harris
Interesting, so PBI recognizes the dimension as time dimension and automatically applies a sort by the date. As far as I remember, PBI has quite a nice timeline intelligence.
You could for example use the timeline slicer (custom visual), there you switch between year/month/day:
Otherwise, you migh add a string-type timestamp instead of the date-field?
HarrisMalik I am certainly using the latest version. It's just that when you apply a time hierarchy the sort by any kind of value dissapears.
I guess using a slicer would be the best thing right now.
Are you able to sort by selecting the sort by column from the modelling toolbar?
