Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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 examp...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Anonymous,

I am unable to reproduce your issue in Power BI Desktop August 2018, what is your data source? You can review my example below.



Regards,
Lydia

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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. 

  • HotChilli's avatar
    HotChilli
    Community Champion
    7 years ago

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago
      Thanks HotChilli.

      Glad it’s not just me then. I’ve had a read through the thread you linked to - it looks like a couple of partial hacks to make some non-text fields appear in ‘see records’ but not a single fix to always return all fields associated with the record? I know our report consumers will unfortunately whine if they cannot see all the underlying fields associated with records.

      Mods - have I interpreted this correctly?

      Thanks :)

      pbix