Sort data for visual

[ysapiyev]

Hi everyone,

I have visual, where I have item names with data and date. I wanted to display only last value. I can't use dax functions, because I have SSAS live connection. So, how can I filter value to display data for each item name for last date. Also, for each item name there can be different last date, so I can't use ton N filtering. Is there any other option?

Regards,

Yerkhan

[v-yuta-msft]

Hi ysapiyev,

You can use visual level filter instead of DAX, click advanced filter-> TOPN.

 

Regards,

Jimmy Tao

[ysapiyev]

@v-yuta-msft

Thanks for your answer. But, as I stated in first message, I can't use Top N, since for every item name there can be different last dates. If I use top N, it will show me top value which satisfy all item names. Consequently, it will show same date for all data.

Is there any other way?

Regards,

Yerkhan