Forum Discussion
See Records and numeric fields
Hi All,
Just wanted to see if this 'just me' or if I am missing something obvious?
I am using Power BI Desktop (August 2018 but similar behaviour in previous versions).
I have, for example, ONE simple single dataset of fields with different data types - e.g. strings, numbers, dates.
When I make a chart from this data - e.g. a normal clustered column chart and click 'see records' I can drill through to the underlying data fine. However, it doesn't show fields where the data types is numeric or dates.
Is there a reason for this and is there an easy fix so that I don't have to cast numeric/date columns to text and duplicate columns in the underlying recordset with text versions of fields?
Thanks,
pbix
8 Replies
Hi Lydia,
Thanks for trying to replicate. My source is a dataset hosted in the Power BI service (but I dont think it is to do with the source - probably a setting on columns like data type maybe?)
It's difficult for me to show you an example because of data confidentiality but this is an example data row:
When I click through to underlying records from a chart the following fields from the fact table are automatically selected/de-selected - the fields that are deselected are dates or integers (particularly note Appt Arrival SDT and Appt Mins ITS from the screenshot above). I can of course tick the deselected fields and this temporarily re-adds them to the view of the record when I click 'see records' but they only stay there as long as I have the 'see records' pane open for.
I'm sure I'm just missing something obvious?
Thanks,
pbix.
I agree with what you are seeing.
From the ms documentation
"When you select See Records for a data element, the Power BI Desktop canvas displays all the data associated with the selected element."
Please see this thread see records
Hi Lydia,
Thanks for your reply but I'm not sure I understand?
Based on thread that HotChilli linked to, by adding the fields that don't automatically appear when I click 'see records' to the 'tooltips' section, this forces the fields to appear. Not the perfect work around but it does work.
Hi Anonymous ah I think I understand what you mean after re-reading. See records shows the remaining fields in the underlying dataset?
Either way, I think it would be better to have more granular control over which fields you can drill through from from charts/measures.
I think being able to drill down to a named set in PBI like you can in SSAS MDX is even more important.
Thanks,
pbix
Anonymous,
Yes. Except the fields used in charts, see records also display the remaining text fields. If you concern about the behavior in see records, you can submit an idea in the Power BI ideas forum.
Regards,
Lydia
