Forum Discussion
Helper IVTo group various data categories into slicer
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.
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
3 Replies
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.
Apple08Many 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.
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