Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

How to order visuals by most recent date?

So my report is going to have a number of donut visuals. This donut visual will also have cards associated with it.   What I want to do is have the top left donut visual represent data related to t...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Anonymous  Here is an example of my data and the result I am looking for:

 

So the visuals would be setup on my report, and when the user filters for Steve, the data relating to ID 203 would appear first, then in the next visual ID 302, and then ID 101. If Joe was filtered, the data relating to ID 321 would appear in the first visual, ID 1045, in the second, and ID 444 in the third visual.

 

I believe I need to create a dynamic rank and use it as a visual filter, however, I don't think I can use measures in a visual filter for a donut chart. 

 

I was trying to see if there was a way to create a dynamic table based on a user's filter selection, and then have the ranking as a column on that dynamic table, but I don't believe you can pass a filter selection to a table.

 

I'm very stumped on this issue and I don't know if it's possible to do in Power BI?

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous ,

Yes, current power bi does not support to create dynamic calculate column/table based on filters.
Notice: filters are works on data view level(visual level) generated from data model tables, they can't affect table records.

Regards,

Xiaoxin Sheng