Forum Discussion
Select a single cell in table
MFelix Your thoughts on this?
The metrics that you can see in table-1 are calculated from DAX and these are shown based on milestones. The table-2 shows a detailed information without any sort of aggregation (source for table-1).
My requirement is if someone clicks on any number in table-1, automatically those records must be shown in table-1. As of now filter is happening based on rows (milestone) but I need the filter to work on the basis of counts (cell).
Is this possible to achieve?
Thanks,
Karthik
- MFelix
Super User
Hi Anonymous ,
This is related with the configuration of your matrix. When you add measure to a matrix you get a column visualization however there is no "column context" (probably not the best word) and when you select the values you are only getting the values where there is "context" in this case the row see image below:
Has you can see since I don't have column I can only select the entire row.
If you add a disconnected table with the measures names and a switch measure you can select individual cells since the "column context" is added to the matrix.
What I did in my case was to create the following table and measure:
SalesMEasuresValues = SWITCH( SELECTEDVALUE(SalesMeasures[ID]), 1, [sales previous year], 2, Sales[sales previous year])Now you need to use the measure has values on the matrix and the column no the table on the columns, also you need to add the measure to filter out the table visualization showing all the values that are not blank:
Has you can see now you can select individual values. In my case the calculations are very simple but in other models I was abble to filter out a list of customer based on the values of sales between certains min and max.
Check PBIX file attach.
