Forum Discussion
See Records on Table
Anonymous Basically what I use this table for is to present a part number (PN_used), Number of failures, the description of the part, and any notes about the failures (if necessary). The number of failures comes from a measure I wrote to only count values that were deemed as the "Primary Failure". This is were the problem somewhat lies. The charts I use are just a total count of the PN_Used whether it was the "Primary Failure" or not. So what is top of the list here might be staggered somewhere in the middle on my chart. If I were to find the corresponding PN_Used on the chart I can use the "see records" capability it would allow me to look at all 29 records that exist where 561-00013-01 was cited as failing. Adding this information to the table would make it look visually unappealing and harder to consume the information. While creating another chart for this information does not allow me to easily see the notes with out using the "see records" capability.
mfminor If I understand you correctly, the data in the chart is what you want to see without losing the notes in the table? What about adding the PN_Used as a slicer. As you determine which specific PN_Used value you want to look at distinctly you could search directly in the slicer and the chart would filter to only showing those parts.
Or, are you asking to be able to drill into the "Number of Failures" measure number? If that is the case, I'm not aware of any solution that would allow you to do this... The only value that you can interact with in a table/matrix would be something that you specify as a URL link...
Anonymous Yes I want to drill down from the table to see the records that create the "number of failures". A slicer is my current work around, I actually have been using the custom visualization called "SmartFilterBySQLBI". Thanks for the help. This pretty much confirms what I already thought.
Sean Yes, kind of, only I would like more than one detail at a time. I currently have fields that would show me repair comments, repair date, return date, sn received, reference designator for the component changed, when the specific unit was packed for shipment, power cycles, and power on time. This is why my team and I find the "See Records" feature on charts to be very interesting. When we have the need to see all that information it is quickly presented in a couple of clicks already pre-filtered to just the units that we care to see.
