To group various data categories into slicer

[Apple08]

Hi All

I have a table of data with various columns of data, e.g. Age, Name, Gender, Address etc.

I would like to extract some data into slicer selection for users to select when viewing data.  Please is there a way to extract data e.g. Age, Name, Gender from the table and I can use it in the slicer selection?  Many thanks.

[Apple08]

Many thanks Neeko.  Please I would like to count how many items in different columns based on years, please could you show me how to do it?

Many thanks.

[Anonymous · Accepted solution]

Hi @Apple08 ,

According to your description, here are my steps you can follow as a solution.

(1) This is my test data.  

(2) We can create a measure. 

count = COUNTROWS(FILTER(ALL('Table'),'Table'[year]=MAX('Table'[year])) )

(3) Then the result is as follows.

If this is different from your expected result, please create a new post for a detailed description of your new problem and expected result.
To make the post more relevant, please mark the correct response to the original problem of the post as the solution, with thanks in advance.

Best Regards,

Neeko Tang

[Anonymous]

Hi @Apple08 ,

Please create a field parameter.

Best Regards,

Neeko Tang

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