Forum Discussion
See Records on Table
mfminor I've been trying to wrap my head around your description, and I just can't seem to do it... Is there a reason you can't just add the columns to the table? It's hard to make recommendations without seeing things, but another alternative would be to add the notes to the table containing the chart info? "See records" shows you everything in the table regardless of what is in the visual, which is what I'm guessing your after.
Could you include some screenshots of what you want?
There are a number of different ways to get a working solution, but one of those obviously doesn't inlcude any interactivity with tables/matrix's.
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.
