Forum Discussion
Helper ICan I change Row and Column months separately in a matrix
Super Userpbilearning not sure what you mean? can you explain bit more?
Ask anything Power BI. Book appointment for a free consultancy at https://www.perytus.com
Helper IHi parry2k
I am trying to create a matrix with count of id as values and categories in rows and columns. I want to create month slicer for them like july month for rows And Aug month for columns. Is it possible to create different slicers for rows and columns in matrix so that I can choose months according to my requirements, instead of just fixing my results to two specific months?
- parry2k
pbilearning I'm sure it can be done with some tweaking/hacking but the question is if the data source is the same, what you expect the result when you filtering rows and columns on different month, isn't data source for both row and column is the same. your requirement is still a bit confusing, may throw some sample data and expected output.
- pbilearning
parry2k I have provided link for your reference.
I have created category and counts in matrix but I am confused how to create option to select rows and column values w.r.t to month selected for them. I am just able to create common slicer of month for the entire matrix instead of creating custom slicer with row and column values provided based on different months selected from the slicer.
PBI FileRequesting for help 🙂
- Ashish_Mathur
Hi,
Is your ultimate objective to know "How many ID's that were Down in August were Neutral in July"?