cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
brianmsbc Frequent Visitor
Frequent Visitor

Sort Filter by value

I need to give the user the ability to filter a dashboard based on a dimension that is sorted by a value (Value represents the dimension that requires the most attention each day).

 

Basically i need to combine the functionality of a filter with the sort capabilities of a table. Any suggestions?

5 REPLIES 5
Super User
Super User

Re: Sort Filter by value

why would be sort relevant in this case? from what you describe you just need filtering functionality

 

can you share samples from both tables?

brianmsbc Frequent Visitor
Frequent Visitor

Re: Sort Filter by value

Stachu,

 

Thanks for the quick response. 

 

The issue is that the filter would contain hundreds of items, and the user needs to be able to see the items that require the most attention at the top (based on a value). 

 

In my mind, it would basically be a slicer that is sorted by a value. 

Community Support Team
Community Support Team

Re: Sort Filter by value

Hi @brianmsbc,

 

Firstly, we can create a measure.

 

Measure = CALCULATE(COUNTROWS(your table))

 

Then we can filter the visual like this by the measure.

 

topn.PNG

 

If it doesn't meet your requirement, kindly share your sample data and excepted result to me. Please upload your files to One Drive and share the link here.

 

Regards,

Frank

 

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Support Team
Community Support Team

Re: Sort Filter by value

Hi @brianmsbc,


Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
brianmsbc Frequent Visitor
Frequent Visitor

Re: Sort Filter by value

It didnt really make sense but i decided to use the matrix feature so that the users could basically filter down from the parent level to the child level. I believe that this accomplished my goal. Thank you for helping!